Distinct Count Power BI Integration

Like (0) Share

Report

Posted on 16 Nov 2023 09:32:26 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:

Using Apps Using Formulas

All responses (2)

Answers (0)

MooreTandT 2 on 17 Nov 2023 at 08:11:10

Like (0)

Report

Re: Distinct Count Power BI Integration

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
v-xiaochen-msft on 17 Nov 2023 at 03:07:55

Like (0)

Report

Re: Distinct Count Power BI Integration

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