Forum Discussion

bhalicki's avatar
bhalicki
Helper V
3 years ago
Solved

COUNTROWS total rows by group

I have the following tables and relationships: User UserId UserName 1 Bill 2 John 3 Fred   License LicenseId LicenseDesc UserId 1 License A 1 2 License B 1 3...
"DAX"
COUNTROWS
  • ERD's avatar
    ERD
    3 years ago

    bhalicki ,

    You can try this measure:

    LicensesAllocated = 
CALCULATE(COUNTROWS(License), FILTER(ALL(License), License[UserId] = SELECTEDVALUE(License[UserId])))

     

ERD's avatar
ERD
Community Champion
3 years ago

bhalicki ,

You can try this measure:

LicensesAllocated = 
CALCULATE(COUNTROWS(License), FILTER(ALL(License), License[UserId] = SELECTEDVALUE(License[UserId])))

 

bhalicki's avatar
bhalicki
Helper V
3 years ago

HI ERD , thankyou that worked perfectly!

Out of interest, do you know why it wouldn't calculate the total for this measure?


Kind regards,

Ben.