Forum Discussion
DAX Formatting inside a Measure?
Hi, I have some Measures, sales, Prices, Share in different measures, to make some of my reports more flexible would I like to have all my measures in one slicer. So what I have done is to creat...
Format the measure as a whole number, but in the price and % values follow this pattern:
VALUES(FilterMeasures[Measure]) = "Price/EAN", FORMAT[Price/EAN], "#,##0.00"),
and
VALUES(FilterMeasures[Measure]) = "Value%Share", FORMAT([Values MS], "#0.0%")
Hi Anonymous ,
you can achieve something like this with Calculation Groups.
https://www.sqlbi.com/articles/controlling-format-strings-in-calculation-groups/