topic Re: Drillup/Drilldown function not working in matrix visual when multiple measures selected from slicer. in DAX Commands and Tips

Drillup/Drilldown function not working in matrix visual when multiple measures selected from slicer.

Anonymous — Thu, 24 Feb 2022 12:16:46 GMT

Hello All,

I have created a measure for selection from slicer.

Measure_Selection =
SWITCH(
SELECTEDVALUE( 'DynamicMeasureTable'[Measure],1),
1 ,'Measure Table'[Measure 1],
2 ,'Measure Table'[Measure 2] * 100,
3 ,'Measure Table'[Measure 3] ,
4 ,'Measure Table'[Measure 4]* 100,
5 ,'Measure Table'[Measure 5],
6 ,'Measure Table'[Measure 6]*100,
7 ,'Measure Table'[Measure 7],
8 ,'Measure Table'[Measure 8]*100,
9 ,'Measure Table'[Measure 9],
10,'Measure Table'[Measure 10]*100,
11,'Measure Table'[Measure 11],
12,'Measure Table'[Measure 12 100,
13, 'Measure Table'[Measure 13],
14, 'Measure Table'[Measure 14]* 100,
15,'Measure Table'[Measure 15],
16,'Measure Table'[Measure 16]* 100
)

While i using this measure in Matrix visual, selected mutiple values from slicer and drill up it is not working as expected(multiple cloumns should drillup and show related data). Only Single column is drilling up.

By using Switch function only its allows sing values selection, is there any way for multiple selections. Please suggest.

Thanks,
Naresh
nareshkandala.21@gmail.com

Re: Drillup/Drilldown function not working in matrix visual when multiple measures selected from slicer.

Russell-PBI — Thu, 24 Feb 2022 14:26:57 GMT

Hi Anonymous, can you provide some screenshots of what you mean as I'm not sure at the moment?

Re: Drillup/Drilldown function not working in matrix visual when multiple measures selected from slicer.

Anonymous — Fri, 25 Feb 2022 09:43:46 GMT

Hi Russell-PBI,

With example Screenshots in details providing.

When multiple values selected in slicer, In Matrix visual at lowest level granulality the selected multiple measures data
are getting in columns(This period's sales and Year to date) refere to Image1

But when drillup to first level only single measure data (this period's sales) is getting refer to image2.

In Visulization pane under fields section -> values selection -> [Sales All Measure] measure is using.

Please find measure logic below:

Sales All Measures =

SWITCH(
SELECTEDVALUE('Measure Selection'[Code],1),
1,[Sales],
2,[Sales YTD],
3,[Sales QTD],
4,[Sales Same Period Last Year],
5,[Cost]
)

Here I want to achive drillup funcationality with multiple measures selections that is selected from silcer.
Please do the needful.

Thanks,
Naresh