Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
abhinaykmr10
Frequent Visitor

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 1Priority 2Priority 3Priority 4
Action DramaComedySci fi 
DramaComedySci fi None
ComedySci 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

 

 

1 ACCEPTED SOLUTION
v-yiruan-msft
Community Support
Community Support

Hi @abhinaykmr10 ,

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

Unpivot all priority columnsUnpivot 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 measuresCreate measures

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

Best Regards

Rena

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yiruan-msft
Community Support
Community Support

Hi @abhinaykmr10 ,

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

Unpivot all priority columnsUnpivot 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 measuresCreate measures

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

Best Regards

Rena

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super User

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.