If condition is meet then to run measure - Advice please.

[shere100]

Hi, 

I have the following measure that I execute. If I have another column with the same table called 'Teams' and I wanted to execute the measure below if the Column 'Team' = 'Support' execute measure below?

How would I execute this?

Measure 2 =
COUNTX (
    FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Test Result] = "Pass" ),
    'Table'[Test Result]
)
    / COUNTX (
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Test Result] = "Not Started" ),
        'Table'[Test Result]
    )

[v-juanli-msft · Accepted solution]

Hi @shere100 

You could create a new measure using the Measure 2 below

new measure= If (MAX('Table'[Team])="Support",[Measure 2])

Modify the bold character.

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.