Hello everyone, I am trying to show how many times a certain location appears within multiple columns onto a dashboard.
Name Location Location 2 Location 3
Go to Solution.
Open Edit queries, click on the "name" column, then unpivot other columns
Create a measure
MAX ( [Value] ) <> BLANK (),
DISTINCTCOUNT ( Table1[Attribute] ),
FILTER ( ALL ( Table1 ), Table1[Value] = MAX ( Table1[Value] ) )
Community Support Team _ Maggie LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
As suggested, after unpivoting, simply drag the value column to the Table visual and write this measure
Measure 1= COUNTROWS(Data)
Hope this helps.
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!