See counts by selected priority channel

Question

Hi,I want to know the audience count based on selected channel priority in Power Bi desktop. Audience have given their choice of movie genre, one person can like one or more than one genre. Genre are Action, Drama, Comedy and Sci fi.Sample DataAudience Id &nbsp; &nbsp;Action &nbsp; &nbsp; &nbsp;Drama &nbsp; &nbsp;&nbsp;Comedy &nbsp; &nbsp;&nbsp;Sci fi &nbsp; &nbsp;&nbsp;100YESYESNONO101YESNONOYES102NOYESNONO103NOYESYESYES104YESYESNONO105YESYESYESNO106YESNOYESNO107NOYESNONO108YESYESYESYES109NONOYESYES110YESYESNONOConsider there are 4 filters: &nbsp;Priority 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Priority 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Priority 3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Priority 4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Action&nbsp;DramaComedySci fi&nbsp;User wants to know the count of movie audiences based on priority selected. 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.Output:&nbsp;Action: 7, Drama: 3, Comedy: 1, Sci fi: 0Note: Output counts should be mutually exclusive and Priority can be none also. If Priority 3 is none then next Priority 4 will be none automatically.&nbsp;Thanks,Abhinay

v-juanli-msft · Accepted Answer

Hi&nbsp;Anonymous&nbsp;
I create four measures and show the correct result:

Please let me know if selecting "Drama", then is the count of each genre like below?

Best RegardsMaggieCommunity Support Team _ Maggie LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

See counts by selected priority channel

2 Replies

Related content

Priority Based Sales Rep Assignment

Slicer priority

Remove duplicates selectively based on priority order

Priority

Fabric Runtime Release Channels

Audience Id	Action	Drama	Comedy	Sci fi
100	YES	YES	NO	NO
101	YES	NO	NO	YES
102	NO	YES	NO	NO
103	NO	YES	YES	YES
104	YES	YES	NO	NO
105	YES	YES	YES	NO
106	YES	NO	YES	NO
107	NO	YES	NO	NO
108	YES	YES	YES	YES
109	NO	NO	YES	YES
110	YES	YES	NO	NO

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