Forum Discussion

juncco888's avatar
juncco888
Advocate I
2 years ago
Solved

New Column with count based on Values from two columns

Hi Everyone,   I am hoping this is simple for someone here but I have been having a devil of a time getting the result I need.   Here is my table   I want a new column that I will call Nr ...
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    juncco888 add column using following DAX:

     

    Count = CALCULATE ( COUNT ( School[SchNr] ), ALLEXCEPT ( School, School[Enrollment Groups] ) )
parry2k's avatar
parry2k
Super User
2 years ago

juncco888 add column using following DAX:

 

Count = CALCULATE ( COUNT ( School[SchNr] ), ALLEXCEPT ( School, School[Enrollment Groups] ) )
juncco888's avatar
juncco888
Advocate I
2 years ago

Thanks so much....  AllExcept is what I was missing.....   I am going to read up on AllExcept because my guess is it will solve many problems for me.  I really appreciate it....