Use DAX to count where and ignoring filters

[sherlycheng]

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

But not affected by Province filter.  

Thank you 🙂

[Zubair_Muhammad]

@sherlycheng

Something like this

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

[sherlycheng]

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. 

 

[sherlycheng]

@Zubair_Muhammad please help 🙂 

[venug20]

@sherlycheng

[Zubair_Muhammad · Accepted solution]

@sherlycheng

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

[sherlycheng]

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

Thanks! @Zubair_Muhammad the solution works! 

[juankypanky]

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