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])))

     

bhalicki's avatar
bhalicki
Icon for Helper V rankHelper V
3 years ago

Hi SamInogic ,

Thanks for your quick reply!  I tried your solution, but I get:

This is the measure (note the RELATED function):

LicenseAllocated = CALCULATE(COUNTROWS(License), FILTER(License, License[UserId] = RELATED(User[UserId])))

These are the relationships:
Users table:

License table:

Any ideas?


 

SamInogic's avatar
SamInogic
Icon for Super User rankSuper User
3 years ago

Hi bhalicki 

It seems that you followed the steps for the solution but created measure instead of the Column in the table.

License Allocated = CALCULATE(COUNTROWS(License), FILTER(License, License[UserId] = User[UserId]))


Can you check the above DAX as a column in the table and add on the report to check output?

Thanks!

Inogic Professional Service Division

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at [email protected]

Service:  http://www.inogic.com/services/ 

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/