Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Get users counts based on selected priority.

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 ...
Need Help
Need Info
  • Anonymous's avatar
    Anonymous
    6 years ago

    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