Displaying how many times item appears within multiple columns

[jcastr02]

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

[Ashish_Mathur]

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.

[v-juanli-msft · Accepted 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.