Forum Discussion

juncco888's avatar
juncco888
Advocate I
3 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
    3 years ago

    juncco888 add column using following DAX:

     

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

juncco888 isn't the last row the value supposed to be 2?

  • juncco888's avatar
    juncco888
    Advocate I
    3 years ago

    Yes...  it is ...   I will corrrect that,...  Thanks for pointing that out