Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
Hi @abhinaykmr10 ,
First, you can unpivot these priority columns in Query Editor as suggested by @amitchandak.
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])
I created a sample pbix file, you can get it from this link.
Best Regards
Rena
Hi @abhinaykmr10 ,
First, you can unpivot these priority columns in Query Editor as suggested by @amitchandak.
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])
I created a sample pbix file, you can get it from this link.
Best Regards
Rena
@abhinaykmr10 , 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/
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |