Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I have two different measures for calculating Turnover because the logic changes if the data is filtered: "Turnover % (Division)" and "Turnover % (Total)"
I'd like to have a third measure that dynamically switches between the two measures depending on if it's evaluating at the Grand Total. The below screenshot is showing a Matrix but I'd also be using this where it's controlled via a slicer (where no selection is made in the slicer = Grand Total).
I've previously been able to switch between measures dynamically using IF(ISFILTERED(...) but that isn't helping here, likely because I need the Grand Total to work in the absence of any filter selection.
My current (not working) measure is below:
Any help is greatly appreciated!
Thank you!
Solved! Go to Solution.
please try the following
manually create a single column table that contains the names of the three measures
create a measure as follows
Turnover (Dynamic) % =
SWITCH (
SELECTEDVALUE ( Measures[MeasureName] ),
"Turnover % (Division)", [Turnover % (Division)],
"Turnover % (Total)", [Turnover % (Total)],
IF (
ISFILTERED ( 'DeptStructure'[Department Code] ),
[Turnover % (Division)],
[Turnover % (Total)]
)
)
Place Measures[MeasureName] in the columns of the matrix and place the above measure at the values.
please try the following
manually create a single column table that contains the names of the three measures
create a measure as follows
Turnover (Dynamic) % =
SWITCH (
SELECTEDVALUE ( Measures[MeasureName] ),
"Turnover % (Division)", [Turnover % (Division)],
"Turnover % (Total)", [Turnover % (Total)],
IF (
ISFILTERED ( 'DeptStructure'[Department Code] ),
[Turnover % (Division)],
[Turnover % (Total)]
)
)
Place Measures[MeasureName] in the columns of the matrix and place the above measure at the values.
I think that did the trick!
I'm happy to know I was somewhat close with how I was approaching it.
Thanks so much!
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |