How to Count with different values in same coloumn

Hi,

I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

 

 

DAX operators - DAX | Microsoft Learn

 

expected result measure: =
CALCULATE (
    COUNTROWS ( VALUES ( 'STATUS'[ID] ) ),
    'STATUS'[STATUS]
        IN { "Waiting on customers", "Pending on user", "Pending Settlement" }
)

 

Hi Goudaaa ,

 

If you want to display the total count after each status, you can try the following measure.

MEASURE = 
VAR _statu =
    MAX ( 'Table'[STATUS] ) = "Waiting on customers"
        || MAX ( 'Table'[STATUS] ) = "Pending on user"
        || MAX ( 'Table'[STATUS] ) = "Pending Settlement"
VAR _count =
    CALCULATE (
        COUNT ( 'Table'[STATUS] ),
        FILTER ( ALL ( 'Table' ), 'Table'[STATUS] = MAX ( 'Table'[STATUS] ) )
    )
VAR _all =
    CALCULATE (
        COUNT ( 'Table'[STATUS] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[STATUS] = "Waiting on customers"
                || 'Table'[STATUS] = "Pending on user"
                || 'Table'[STATUS] = "Pending Settlement"
        )
    )
RETURN
    IF (
        ISINSCOPE ( 'Table'[STATUS] ) && _statu,
        _count,
        IF ( NOT ISINSCOPE ( 'Table'[STATUS] ), _all )
    )

 

If your Current Period does not refer to this, please clarify in a follow-up reply.

 

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.