Forum Discussion

Vkl's avatar
Vkl
Frequent Visitor
1 year ago
Solved

Multiple Data formats inside Switch DAX MEASURE

I have around 10 measures where 5 were just sum aggregation of direct columns and 5 were calculated for percentage. And I wanted to show all these measures in the Matrix visual. So i created a DAX me...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • Vkl's avatar
    Vkl
    1 year ago

    bhanu_gautam Thanks for the help! This worked but the individual rows were still blank, so i created a new measure and added all the formats at once and used it as a Value field in the matrix visual. That worked

    IF(
    NOT(ISBLANK(MetricValue)),
    SWITCH(
    SelectedMetric,
    "Orders", FORMAT(MetricValue, "0.0;(0.0)"),
    "Orders SM%", FORMAT(MetricValue/100, "0.0%"),
    FORMAT(MetricValue, "0.0") -- Default
    ),
    BLANK()

bhanu_gautam's avatar
bhanu_gautam
Super User
1 year ago

Vkl , Try using

 

DAX
FormattedMeasure =
SWITCH (
TRUE (),
metrics = "Orders SM%" && quarter = "Q1" && year = "2024" && Names = "Actuals", FORMAT([Input_Table_OrdersSM%1Q24], "Percent"),
metrics = "Orders SM%" && quarter = "Q2" && year = "2024" && Names = "Actuals", FORMAT([Input_Table_OrdersSM%2Q24], "Percent"),
metrics = "Sales" && quarter = "Q1" && year = "2024" && Names = "Actuals", FORMAT([Input_Table_Sales1Q24], "0.00"),
metrics = "Sales" && quarter = "Q2" && year = "2024" && Names = "Actuals", FORMAT([Input_Table_Sales2Q24], "0.00"),
...
BLANK()
)

Vkl's avatar
Vkl
Frequent Visitor
1 year ago

bhanu_gautam Thanks for the help! This worked but the individual rows were still blank, so i created a new measure and added all the formats at once and used it as a Value field in the matrix visual. That worked

IF(
NOT(ISBLANK(MetricValue)),
SWITCH(
SelectedMetric,
"Orders", FORMAT(MetricValue, "0.0;(0.0)"),
"Orders SM%", FORMAT(MetricValue/100, "0.0%"),
FORMAT(MetricValue, "0.0") -- Default
),
BLANK()