Switch between Units and Value using Calculation Groups

DAX DAX Calculations
1

Hi,

Is there a way I can switch from Units to Value in Calculation groups.
Currently my matrix is displaying Total Sales measure.

My calculation

Calculation group
Calculation group879×547 24.4 KB

2

Do you want to change the number format from integer to currency?
If so, you need to enable dynamic format

image
image1182×571 57.4 KB

image

3

Hi,
No, as you can see from the screen shot I have on top Field Parameters, and I have also used Calculation Groups for Time Intelligence, but these are showing only Total Sales, is there a way that I can use slicer or Field parameters or even calculation groups to switch between Total Sales and Total units sold. Currently they only show total sales.

Calculation group
Calculation group1280×720 208 KB

4

Hi All,
I actually found out the solution by playing around a little bit with Calculation Groups.
Its simple and you need to create another Calculation Group with 2 items referring to Total Sales measure and Total Qty measure and then bring this into a slicer. :blush:
By the way this is done in the new semantic model and not Tabular Editor.