Count group by

[M_SBS_6]

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.

[Anonymous]

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

[Daniel29195]

@M_SBS_6 

can you please show an example of what you want, using sample data ? 

best regaards