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 in EG that counts the number of distinct schools numbers within an enrollmen group so the results would look like this

 

SchNrEnrollment GroupsNr in EG
15<1001
110201-3502
123>3502
134100-2001
163201-3502
167>3502

 

 

I have measures that give me this count for each enrollment group already but I need a single column that tells me the total number of schools so next to a school i can see the number of schools that are in the same enrolment group.

 

Any assitance would be greatly appreciated.

 

Thanks

 

Kyle

 

Edit:  Corrected expected output

 

  • juncco888 add column using following DAX:

     

    Count = CALCULATE ( COUNT ( School[SchNr] ), ALLEXCEPT ( School, School[Enrollment Groups] ) )

4 Replies

    • juncco888's avatar
      juncco888
      Advocate I

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

       

  • juncco888 add column using following DAX:

     

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

      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....