Forum Discussion

M_SBS_6's avatar
M_SBS_6
Icon for Helper V rankHelper V
2 years ago

Count group by

Hi,    How would you write a measure to count distinct and then group by 2 different columns of data?    Distinct count AppId group by AppType and AppStatus.
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, M_SBS_6 

 

Based on your description, you can try the following DAX and if it doesn't work, you can share the pbix file with no sensitive data, the data table (please don't give screenshots), the desired effect and the logic to achieve that effect. Feel free to help you about this problem.


Measure:

 

 

DistinctCountByTypeStatus =
VAR CombinedTypeStatus = CONCATENATE(YourTable[AppType], " - ", YourTable[AppStatus])
RETURN
CALCULATE(
DISTINCTCOUNT(YourTable[AppId]),
FILTER(YourTable, YourTable[AppType] & " - " & YourTable[AppStatus] = CombinedTypeStatus)
)

 


Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum