FORMAT ignores filter

When I apply the FORMAT function in the following measure, my matrix visual ignores the slicer filter, and displays blank columns. Here is the measure code: ERMetricValue = var sel = SELECTEDVALUE...

Need Help

v-eachen-msft

6 years ago

Hi Anonymous ,

You could use IF() to hide blank values.

var ret =
IF (
    val <> BLANK (),
    SWITCH (
        sel,
        "Preventable Percent", FORMAT ( val, "###%" ),
        "Avoidable Percent", FORMAT ( val, "###%" ),
        "Allowed Amount", FORMAT ( val, "$#,##0" ),
        "Paid Amount", FORMAT ( val, "$#,##0" ),
        "Visits", FORMAT ( val, "#,##0" ),
        "Avoidable", FORMAT ( val, "#,##0" ),
        "Preventable", FORMAT ( val, "#,##0" )
    )
)

Forum Discussion

FORMAT ignores filter

Related content

Make measure ignore specific filter

Ignore filter for a measure

How to ignore Filter

Sum ignoring filter

Dax calculate total amount ignoring filter