How to Count with different values in same coloumn

[Goudaaa]

• Hey There,
• I just want to count with different values in the same coloumn like this example:
• CALCULATE(COUNT('STATUS'),'STATUS' = "Waiting on customers",'STATUS' = "Pending on user", 'STATUS' = "Pending Settlement") 
• Like the above example I need the total count of all conditions like if the Waiting on customers = 167 and Pending on User = 768 and Pending Settlement = 600 I need the sum of them as the result
• I hope I described my need in a good way and TIA for your help

[Jihwan_Kim · Accepted solution]

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" }
)

[v-kaiyue-msft · Accepted solution]

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.

[Jihwan_Kim · Accepted solution]

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" }
)