Forum Discussion
Power Apps Power BI Integration Distinct Count
First, ensure you are accessing the full dataset from Power BI. Since `First(PowerBIIntegration.Data)` only gets the first record, you should use `PowerBIIntegration.Data` to access the entire dataset.
Use the `Distinct()` function to create a table of distinct values from the 'Section' column. The syntax will be something like `Distinct(PowerBIIntegration.Data, Section)`.
Finally, use the `CountRows()` function to count the number of rows in the distinct table you created. The final formula will look like `CountRows(Distinct(PowerBIIntegration.Data, Section))`.
CountRows(Distinct(PowerBIIntegration.Data, Section))
Thanks alot for your reply. I should have explained it better. The First function was correct in the previous excersise, I was just using it as an example. I just tried yours and it works perfectly, I was trying to put .Section in rather than , - as I assumed that's the way it had to be. Great, thanks
I am glad to help 🙂