topic Re: Distinct Count with Multiple Conditions in DAX Commands and Tips

Distinct Count with Multiple Conditions

scalonia — Thu, 18 Aug 2022 14:55:45 GMT

How can I create a distinct count with this condition? Status column will be completed once the new routine column has value.

Re: Distinct Count with Multiple Conditions

scalonia — Thu, 18 Aug 2022 15:58:03 GMT

Re: Distinct Count with Multiple Conditions

tamerj1 — Thu, 18 Aug 2022 17:15:43 GMT

Hi scalonia

please try

Status = VAR T1 = CALCULATETABLE ( 'Table 1', ALLEXCEPT ( 'Table 1', 'Table 1'[Entity ID] ) ) VAR T2 = FILTER ( T1, 'Table 1'[New Routine] <> BLANK () ) RETURN IF ( COUNTROWS ( T1 ) = COUNTROWS ( T2 ) && COUNTROWS ( T2 ) > 1, "Completed", "Not Completed" )

Re: Distinct Count with Multiple Conditions

scalonia — Fri, 19 Aug 2022 00:02:36 GMT

It works! Thank you!

Re: Distinct Count with Multiple Conditions

scalonia — Thu, 25 Aug 2022 15:08:08 GMT

Re: Distinct Count with Multiple Conditions

scalonia — Thu, 25 Aug 2022 15:09:10 GMT

Would you be able to help me on this? For this entity #, if 1 is yes, then the result is satisfied.

Re: Distinct Count with Multiple Conditions

tamerj1 — Thu, 25 Aug 2022 15:44:53 GMT

scalonia

Status 2 = VAR T1 = CALCULATETABLE ( VALUES ( 'Table 1'[New Routine] ), ALLEXCEPT ( 'Table 1', 'Table 1'[Entity ID] ) ) RETURN IF ( "Yes" IN T1, "Satisfied", "Not Satisfied" )

Re: Distinct Count with Multiple Conditions

scalonia — Fri, 26 Aug 2022 00:40:47 GMT

Did not work