Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

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
[email protected]


2 Replies

  • Russell-PBI's avatar
    Russell-PBI
    Icon for Resolver II rankResolver II
    4 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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,
      NareshImage1Image2