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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
sherlycheng
Frequent Visitor

Use DAX to count where and ignoring filters

How can I write DAX to count(type) where Type ='A'

But not affected by Province filter.  

 

Thank you 🙂

 

a.PNG

1 ACCEPTED SOLUTION

@sherlycheng

 

Measure =
CALCULATE (
    COUNT ( TableScore[Score] ),
    TableScore[User Type] = "Promotor",
    ALL ( TableProvince[Province] )
)

Regards
Zubair

Please try my custom visuals

View solution in original post

7 REPLIES 7
Zubair_Muhammad
Community Champion
Community Champion

@sherlycheng

 

Something like this

 

Measure =
CALCULATE (
    COUNT ( Table1[Type] ),
    FILTER ( ALL ( Table1 ), Table1[Type] = "A" )
)

Regards
Zubair

Please try my custom visuals

Hi @Zubair_Muhammad 

 

Thanks for the answer. 

 

If I want to count(Score) where User Type = 'Promotor' but not affected by the Province filter in Table Province

How should I write the dax? 

 

Thanks before. 

 

 

 power BI.PNG

@Zubair_Muhammad please help 🙂 

@sherlycheng

 

 

 

Sample-Province.jpg

@sherlycheng

 

Measure =
CALCULATE (
    COUNT ( TableScore[Score] ),
    TableScore[User Type] = "Promotor",
    ALL ( TableProvince[Province] )
)

Regards
Zubair

Please try my custom visuals

Thank you @Zubair_Muhammad @venug20 @juankypanky for the help! really appreciate it!  

Thanks! @Zubair_Muhammad the solution works! 

Try with this (sorry if it doesn't work):

 

Measure =
CALCULATE (
SUMX ( TableScore[Score] ),
FILTER ( ALL ( TableScore ), TableScore[User Type] = "Promotor" )
)

*Take care with the name of the fields and tables

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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