Filtering/Slicing Group of measures

Anonymous — Mon, 24 Oct 2022 08:25:09 GMT

Hey,

We are having issues with filtering/slicing group of measures.

Dax formula should work on logic that when selecting dimension (WTD or MTD or YTD) we see in matrix table sliced only measures that are under selected group. In order to slice this we have created table with all measures in example below.

All below measures are held in matrix table, and by default they all can be seen, but after selection they should be sliced to selected value.

There are similar solutions where slicing is based on showing and switching only one measure at a time, but we are having trouble to expand these formulas and slicing to more than one measure that should be switched.

All Measures/ Columns that are entered in matrix table - All can be seen by default when selection is not active.

Actual WTD

abs vs LY WTD

% vs LY WTD

abs vs BP WTD

% vs BP WTD

abs vs RE WTD

% vs RE WTD

Actual MTD

abs vs LY MTD

% vs LY MTD

abs vs BP MTD

% vs BP MTD

abs vs RE MTD

% vs RE MTD

Actual YTD

abs vs LY YTD

% vs LY YTD

abs vs BP YTD

% vs BP YTD

abs vs RE YTD

% vs RE YTD

Example with WTD Selection:

Table entered as filter

On Selected value

User Selection Dim = SELECTEDVALUE('000_Measures_Filter'[Filter Dimension])

Slicing only measures that are selected in matrix table.

000_Measures_Filter Table with all measures with belonging group (Filter Dimension).

Filter Dimension	Measure
WTD	Actual WTD
WTD	abs vs LY WTD
WTD	% vs LY WTD
WTD	abs vs BP WTD
WTD	% vs BP WTD
WTD	abs vs RE WTD
WTD	% vs RE WTD
WTD	Actual IC MIX WTD
WTD	BP IC MIX WTD
WTD	% Point vs BP WTD
MTD	Actual MTD
MTD	abs vs LY MTD
MTD	% vs LY MTD
MTD	abs vs BP MTD
MTD	% vs BP MTD
MTD	abs vs RE MTD
MTD	% vs RE MTD
MTD	Actual IC MIX WTD
MTD	BP IC MIX WTD
MTD	% Point vs BP WTD
YTD	Actual YTD
YTD	abs vs LY YTD
YTD	% vs LY YTD
YTD	abs vs BP YTD
YTD	% vs BP YTD
YTD	abs vs RE YTD
YTD	% vs RE YTD
YTD	Actual IC MIX WTD
YTD	BP IC MIX WTD
YTD	% Point vs BP WTD

Let me know if any more information is needed

Thanks,

Re: Filtering/Slicing Group of measures

daXtreme — Mon, 24 Oct 2022 09:33:18 GMT

I read this but don't understand; too much noise. Would you please post some data demonstrating the issue and/or good pictures with explanations? Even better, please create a pbix file that highlights the issue and then place a link to it here so that we can inspect and advise. You can place the file on any of the shared drives that people normally use, Google Drive, OneDrive... Thanks.

Re: Filtering/Slicing Group of measures

Anonymous — Mon, 24 Oct 2022 13:39:36 GMT

Hello,

Please find PBI example file on the OneDrive link with dummy values. Voluime_Forum_Share

Below is print screen of what should happen when filter is selected.

Please advise if I can clarify this additionaly.

Thanks.

topic Re: Filtering/Slicing Group of measures in DAX Commands and Tips

Filtering/Slicing Group of measures

Actual WTD

abs vs LY WTD

% vs LY WTD

abs vs BP WTD

% vs BP WTD

abs vs RE WTD

% vs RE WTD

Actual MTD

abs vs LY MTD

% vs LY MTD

abs vs BP MTD

% vs BP MTD

abs vs RE MTD

% vs RE MTD

Actual YTD

abs vs LY YTD

% vs LY YTD

abs vs BP YTD

% vs BP YTD

abs vs RE YTD

% vs RE YTD

Re: Filtering/Slicing Group of measures

Re: Filtering/Slicing Group of measures