Forum Discussion

bhalicki's avatar
bhalicki
Icon for Helper V rankHelper 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
Icon for Community Champion rankCommunity 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
    Icon for Helper V rankHelper 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.