Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Joel Castro | Orlando | |||
Chandle Grant | Miami Lakes | Chandler | ||
Rabia Mahmood | Miami Lakes | Muscle Shoals | Chandler | |
Daniel Arceus | Chandler | Orlando | ||
Victor Smith | Orlando | Chandler | Miami Lakes |
Solved! Go to Solution.
Hi @jcastr02
Open Edit queries, click on the "name" column, then unpivot other columns
Close&&apply
Create a measure
Measure = IF ( MAX ( [Value] ) <> BLANK (), CALCULATE ( DISTINCTCOUNT ( Table1[Attribute] ), FILTER ( ALL ( Table1 ), Table1[Value] = MAX ( Table1[Value] ) ) ) )
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
As suggested, after unpivoting, simply drag the value column to the Table visual and write this measure
Measure 1= COUNTROWS(Data)
Hope this helps.
Hi @jcastr02
Open Edit queries, click on the "name" column, then unpivot other columns
Close&&apply
Create a measure
Measure = IF ( MAX ( [Value] ) <> BLANK (), CALCULATE ( DISTINCTCOUNT ( Table1[Attribute] ), FILTER ( ALL ( Table1 ), Table1[Value] = MAX ( Table1[Value] ) ) ) )
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |