Get users counts based on selected priority.

[Anonymous]

Hi,

I want to know users count based on selected channel priority.

Consider there are 4 filters:  

Priority 1	Priority 2	Priority 3	Priority 4
Action	Drama	Comedy	Sci fi
Drama	Comedy	Sci fi	None
Comedy	Sci fi	None
Sci fi	None
None

User want to know the count of movie audiences based on priority given by audiences. If Priority 1 is Action then action should not come in other priority options. Based on selected priority, User want to know the count of different audiences who are selected.

Thanks,

Abhinay

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ,

First, you can unpivot these priority columns in Query Editor as suggested by @amitchandak.

Unpivot all priority columns

Then create measures as below to get the count of movie audiences

Measure = 
VAR _a =
    CALCULATE ( DISTINCTCOUNT ( 'Table'[Type] ) ) 
RETURN
    IF ( NOT ( ISBLANK ( _a ) ) && MAX ( 'Table'[Type] ) <> "", _a )

Measure 2 = SUMX(VALUES('Table'[Type]),[Measure])

Create measures

I created a sample pbix file, you can get it from this link.

Best Regards

Rena

[amitchandak]

@Anonymous , I think you should unpivot this data

https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/