Format Switch Measure

Anonymous — Tue, 12 Sep 2023 19:20:48 GMT

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

Re: Format Switch Measure

Anonymous — Tue, 12 Sep 2023 20:42:57 GMT

topic Format Switch Measure in DAX Commands and Tips

Format Switch Measure

Re: Format Switch Measure