CALCULATE(COUNTA(yourTable[Person]),ALLEXCEPT(yourTable,yourTable[Person]))

[Anithabs]

I need to understand how this will work can anyone explain this?

[amitchandak · Accepted solution]

@Anithabs ,

ALLEXCEPT means keep that filter. So in this all filter other than perosn will ignored. You will get person count by removing filter of all other than person.

If display by person. you will see 1. For most of the other groups it will be like sub total

refer these

https://www.sqlbi.com/articles/using-allexcept-versus-all-and-values/

https://www.sqlbi.com/articles/managing-all-functions-in-dax-all-allselected-allnoblankrow-allexcept...

[Jihwan_Kim · Accepted solution]

Hi, @Anithabs 

In my case, I try to create other measures that generate the same result.

I am not sure about how your whole data model looks like, but I created a sample pbix file like below.

And wrote two more measures that are easier to understand than allexcept (just my opinion).

New Measure Allselect =

CALCULATE(COUNTA(yourTable[Person]),ALLSELECTED( yourTable[Category], yourTable[Subject]))

New Measure removefilters =

CALCULATE(COUNTA(yourTable[Person]),REMOVEFILTERS(yourTable[Category]), REMOVEFILTERS(yourTable[Subject]))

https://www.dropbox.com/s/z7xkedg0yjya24w/sample0520.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[amitchandak · Accepted solution]

@Anithabs ,

ALLEXCEPT means keep that filter. So in this all filter other than perosn will ignored. You will get person count by removing filter of all other than person.

If display by person. you will see 1. For most of the other groups it will be like sub total

refer these

https://www.sqlbi.com/articles/using-allexcept-versus-all-and-values/

https://www.sqlbi.com/articles/managing-all-functions-in-dax-all-allselected-allnoblankrow-allexcept...