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
PhilipTreacy
Super User
Super UserHi StuartSmith
Download PBIX file with the example below
Try this
Measure = CALCULATE(COUNTROWS('DataTable'), FILTER(ALL('DataTable'),'DataTable'[Country] = SELECTEDVALUE('DataTable'[Country])))
Regards
Phil
StuartSmithPower Participant
Power ParticipantAwesome & Thanks