Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello all,
I have a table visual in PBI and wanted to see how many records are there on that visual.
The measure that I created Row Count = COUNTROWS('Table_Name') will give me total number of rows in the dataset but not in the table visual I have.
See in below example, I have only two rows of records, but row count will say 4, that is not correct in my case.
How can I get this correct number of rows?
Thanks,
pthapa
Solved! Go to Solution.
Hi @pthapa, jdbuchanan71, thank you for your prompt reply!
Try the following measure:
Row Count Visual = COUNTROWS(SUMMARIZE(ALLSELECTED('Table'), 'Table'[CustomerName], 'Table'[CustomerID]))
Result:
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @pthapa, jdbuchanan71, thank you for your prompt reply!
Try the following measure:
Row Count Visual = COUNTROWS(SUMMARIZE(ALLSELECTED('Table'), 'Table'[CustomerName], 'Table'[CustomerID]))
Result:
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello @v-yajiewan-msft ,
Appreciate your response, yes the trick does work finally. I had to put all the columns that are in the visual to summarize, then it worked.
Thanks again.
pthapa
Not sure why, the total doesn't work for all. Anyone has idea how to fix the total?
It seems working for some but not for all if I use the filter for Customer No to check.
Thanks,
pthapa
@jdbuchanan71 ,
Thanks for quick response however the distinct count will not give correct total at the bottom, why?
See example below.
Because the count of unique customer no_ is 1 (100004), it is not organized the way I thought. Take a look at Visual level calculations, you might need to go down that route since you are only wanting to cout the rows shown in the table.
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-visual-calculations-overview
Total Still isn't working, why?
Thanks,
pthapa
User | Count |
---|---|
117 | |
73 | |
58 | |
49 | |
48 |
User | Count |
---|---|
171 | |
122 | |
60 | |
59 | |
56 |