Forum Discussion

Jkaelin's avatar
Jkaelin
Icon for Resolver I rankResolver I
7 years ago
Solved

CountX by Category

Hey everyone,

 

Struggling to correct write this measure.

 

I want to return the distinct count of the categories that have a status of 1, more than once.  

 

Below, the result should be 2.  I want to count each category (A & F) that have a status of 1 that is counted more than once.  Each category will have a status of 1, but I want the unique count of each category that has it listed more than once.  

 

Thoughts?  Any help is greatly appreciated.  Thank you!!

 

 

 

Need Help
  • LivioLanzo's avatar
    LivioLanzo
    7 years ago

    Hi Jkaelin

     

    =COUNTROWS(
    FILTER(
        VALUES( Statuses[Category] ),
        CALCULATE( COUNTROWS( Statuses ), Statuses[Status] = 1 ) > 1
    )
)

2 Replies

  • LivioLanzo's avatar
    LivioLanzo
    Icon for Solution Sage rankSolution Sage
    7 years ago

    Hi Jkaelin

     

    =COUNTROWS(
    FILTER(
        VALUES( Statuses[Category] ),
        CALCULATE( COUNTROWS( Statuses ), Statuses[Status] = 1 ) > 1
    )
)