Unanswered

Distinct Count Power BI Integration

(0) Share

Report

Posted on by MooreTandT

Hi all,

I want to do a distinct count of values from a column which is coming in through Power BI integration (Power BI Integration is up and working well). So far I have been using this to take the first section:

First(PowerBIIntegration.Data).Section

It would be using the same item as above, but where the table shows the below I just need the answer to be 2:

Section

1.1.2.4

1.1.1.1

Many thanks for any help,

Nick

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

v-xiaochen-msft on at

Like (0)

Report

Hi @MooreTandT ,

Please try to use distinct function.

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-distinct

Distinct(First(PowerBIIntegration.Data).Section,Section)

Best Regards,

Wearsky

Was this reply helpful? Yes No
MooreTandT 2 on at

Like (0)

Report

Hi Wearsky,

Thanks as lot for your reply.

unfortunately that formula is throwing an error as per below:

I think because it just says Section in the area highlighted, it always needs to reference the Power BI integration (this is the only place where Section exists) - I'm unsure why it says {0} isn't recognised though?

I tried replacing it as per below but with no joy.

Cheers,

Nick

Was this reply helpful? Yes No