Forum Discussion

Alan_Gould's avatar
Alan_Gould
Frequent Visitor
3 years ago
Solved

Formatting multiple KPIs in a table - using Switch and FORMAT

Hi Experts, 

 

I have a table that has 30KPIs, some are % some are $. 

 

How can I use the below DAX for multiple KPIs? 

 

Format_Values = VAR _selvalKPI1 =
    SELECTEDVALUE( 'Data'[KPI_ID] )
RETURN
    SWITCH (
        TRUE(),
            _selvalKPI1 = "KPI1", FORMAT(
                SUM('Data'[Value]),
                "0.0 mins"
))

 

 

Thanks, 

Alan

Need Help
  • MFelix's avatar
    MFelix
    3 years ago

    Hi Alan_Gould ,

     

    The switch function allows you to do several conditions so you need to do something similar to:

     

    Format_Values = VAR _selvalKPI1 =
    SELECTEDVALUE( 'Data'[KPI_ID] )
RETURN
    SWITCH (
        _selvalKPI1,
            "KPI1", FORMAT(
                SUM('Data'[Value]),
                "0.0 mins"
),
"KPI2", FORMAT(
                SUM('Data'[Value2]),
                "#.###"
),
"KPI3", FORMAT(
                SUM('Data'[Value3]),
                "#.##%"
)

)

1 Reply

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    3 years ago

    Hi Alan_Gould ,

     

    The switch function allows you to do several conditions so you need to do something similar to:

     

    Format_Values = VAR _selvalKPI1 =
    SELECTEDVALUE( 'Data'[KPI_ID] )
RETURN
    SWITCH (
        _selvalKPI1,
            "KPI1", FORMAT(
                SUM('Data'[Value]),
                "0.0 mins"
),
"KPI2", FORMAT(
                SUM('Data'[Value2]),
                "#.###"
),
"KPI3", FORMAT(
                SUM('Data'[Value3]),
                "#.##%"
)

)