I need some help on a dynamic measure header display based on slicer selections.
Currently, my measure header is as follows by default (without slicer selection):
Total Sales
Total Cost
Total GP
But when my slicer of subsidiary is selected (for example ABC or XYZ), i need to measure header to change accordingly to below, depending on single selection.
If multiple selections then default header applies.
Sales for ABC
Cost for ABC
GP for ABC
or
Sales for XYZ
Cost for XYZ
GP for XYZ
I have seem a few number of tutorials but mostly are dealing with dynamic column headers and I have no idea how to apply to measures. Bookmarks will not help as well since it might reverse selections of other slicers.
Many thanks in advance!
Cheers!
Regards
Shao
Sales Header =
IF (
HASONEVALUE ( Subsidiary[Name] ),
"Sales for " & VALUES ( Subsidiary[Name] ),
"Total Sales"
)
Cost Header =
IF (
HASONEVALUE ( Subsidiary[Name] ),
"Cost for " & VALUES ( Subsidiary[Name] ),
"Total Cost"
)
GP Header =
IF (
HASONEVALUE ( Subsidiary[Name] ),
"GP for " & VALUES ( Subsidiary[Name] ),
"Total GP"
)