Can someone help me how to create one measure in which I can present different data (e.g. Revenue, Profit, Profit margin) based on the chosen filter?
Filter contains mentioned values (e.g. Revenue, Profit, Profit margin) and by choosing the value, data set should be switched to requested value. Also, we have new currency filter (e.g. $, €...) which needs to be reflected on the same value.
Currently, I’m using DAX and edit relationship on the slicer level to solve it. I’m hoping there is an easier way. Can anyone help, please? Please find the visual in the picture below.