scaloniaRegular Visitor4 years agoSolvedDistinct Count with Multiple Conditions How can I create a distinct count with this condition? Status column will be completed once the new routine column has value. Show Moretamerj14 years agoHi 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" )
tamerj14 years agoHi 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" )
tamerj14 years agoHi 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" )
tamerj1Community Champion4 years agoscalonia 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" )
Related contentDistinct Count with multiple conditionsMultiple conditions IndexMultiple Donut charts with conditionsConditional Column with Multiple Conditionsdistinct count of multiple columns
