Forum Discussion
Format Switch Measure
Hi,
I am trying to use a switch measure with a silcer so the user can toggle between sales, GP $ and GP % on the same visual. How can i format the GP% to a %?
Below is my measure:
Measure Selection MTD = IF(ISCROSSFILTERED('Measure Types'[Measure Type]),
SWITCH(TRUE(),
VALUES('Measure Types'[Measure Type]) = "Sales", [Total Sales],
VALUES ('Measure Dimensions'[Measure Type])= "Margin $", [Total Product Margin (Unit Cost)],
VALUES ('Measure Types'[Measure Type])= "Margin %", [Prod Margin %],
BLANK()),BLANK())
Thank you