topic Re: How to Count with different values in same coloumn in DAX Commands and Tips

How to Count with different values in same coloumn

Goudaaa — Sun, 22 Sep 2024 01:16:16 GMT

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

Re: How to Count with different values in same coloumn

Jihwan_Kim — Sun, 22 Sep 2024 03:47:52 GMT

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

Re: How to Count with different values in same coloumn

Anonymous — Tue, 24 Sep 2024 02:43:22 GMT

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.