Forum Discussion

M_SBS_6's avatar
M_SBS_6
Helper 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

2 Replies

  • Daniel29195's avatar
    Daniel29195
    Community Champion
    2 years ago

    M_SBS_6 

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

     

     

    best regaards

  • 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