Forum Discussion
Invert values in a visual?
- 5 years ago
you can create a calculation group item in tabular editor, and then use that item, which is a measure to apply to all the measures in your model, by use of a slicer you apply the calculation group measure to your measure it and you can get the inverse, but it obviously depends on how you want to use it.
see pbix example, but you will need tabular editor to see the calculation item
https://www.sqlbi.com/tools/tabular-editor/ --> download tabular editor if you haven't already, its awesome
watch this video with the details on how to use create the calculation group https://www.youtube.com/watch?v=xS1t25_GsWw
i think you can probably use this code for your calculation item. depending on how you use it.
selectedmeasure() * -1
i just saw this in linked in but not sure if its of any use to you?
https://www.linkedin.com/posts/daniilmaslyuk_powerbi-activity-6788412485411106816-HaBt
Thank you for the tip. I think the calculation groups is what i am looking for, but this could be handy for a quick fix. But i am not able to test it, i cant see this option. Maybe my desktop application is not updated 😐