Stack DAX measures into single measure

[Anonymous]

I have three measures which I hope can be combined into a single measure, but I am not clever enough to figure this out.

The first measure counts number of audits

The second measure counts number of fails

The third measure divides fails by audits to get a fail ratio

I only need the fail ratio really, the other two measures I created in order to get to it.

here are the measures:

Payment Currency Checked = CALCULATE(

COUNT('Claim Loaders 2018'[$$-Payment Currency]),

FILTER('Claim Loaders 2018', 'Claim Loaders 2018'[$$-Payment Currency]<>"N/A"))

Payment Currency Fail = CALCULATE(

COUNT('Claim Loaders 2018'[$$-Payment Currency]),

FILTER('Claim Loaders 2018', 'Claim Loaders 2018'[$$-Payment Currency]="Fail"))

Payment Currency Fail Ratio = DIVIDE([Payment Currency Fail],[Payment Currency Checked])

[v-frfei-msft · Accepted solution]

Hi @Anonymous,

Please try to use the combined one.

PaymentCurrencyFailRatio =
VAR _PaymentCurrencyChecked =
    CALCULATE (
        COUNT ( 'Claim Loaders 2018'[$$-Payment Currency] ),
        FILTER (
            'Claim Loaders 2018',
            'Claim Loaders 2018'[$$-Payment Currency] <> "N/A"
        )
    )
VAR _PaymentCurrencyFail =
    CALCULATE (
        COUNT ( 'Claim Loaders 2018'[$$-Payment Currency] ),
        FILTER (
            'Claim Loaders 2018',
            'Claim Loaders 2018'[$$-Payment Currency] = "Fail"
        )
    )
RETURN
    _PaymentCurrencyFail / _PaymentCurrencyChecked

Regards,

Frank