Accumulated count if

chrisgehm

Hi, you can try to obtain your result with this:

Count to Cond1 is 0 and Cond2 Open and Cond3 is A =
COUNTROWS (
    FILTER (
        Table1,
        Table1[Cond1] = 0
            && Table1[Cond2] = "Open"
            && Table1[Cond3] = "A"
    )
)

Count to Cond1 is 0 and Cond2 Open =
COUNTROWS ( FILTER ( Table1, Table1[Cond1] = 0 && Table1[Cond2] = "Open" ) )

Result =
DIVIDE (
    [Count to Cond1 is 0 and Cond2 Open and Cond3 is A],
    [Count to Cond1 is 0 and Cond2 Open],
    BLANK ()
)

With 3 measure or All together in a single Measure

Measure =
VAR Count_to_Cond1_is_0_and_Cond2_Open_and_Cond3_is_A =
    COUNTROWS (
        FILTER (
            Table1,
            Table1[Cond1] = 0
                && Table1[Cond2] = "Open"
                && Table1[Cond3] = "A"
        )
    )
VAR Count_to_Cond1_is_0_and_Cond2_Open =
    COUNTROWS ( FILTER ( Table1, Table1[Cond1] = 0 && Table1[Cond2] = "Open" ) )
RETURN
    DIVIDE (
        Count_to_Cond1_is_0_and_Cond2_Open_and_Cond3_is_A,
        Count_to_Cond1_is_0_and_Cond2_Open,
        BLANK ()
    )

Regards

Victor

Lima - Peru