Forum Discussion
StuartSmith
Power Participant
Power ParticipantCount all rows per country.
How can I create a measure that will display in a table visual the number of rows per "Country", similar to the below?
Thanks in advance.
Hi StuartSmith
Download PBIX file with the example below
Try this
Measure = CALCULATE(COUNTROWS('DataTable'), FILTER(ALL('DataTable'),'DataTable'[Country] = SELECTEDVALUE('DataTable'[Country])))Regards
Phil
2 Replies
- PhilipTreacy
Super User
Hi StuartSmith
Download PBIX file with the example below
Try this
Measure = CALCULATE(COUNTROWS('DataTable'), FILTER(ALL('DataTable'),'DataTable'[Country] = SELECTEDVALUE('DataTable'[Country])))Regards
Phil
StuartSmithAwesome & Thanks