Forum Discussion

RafaelAri's avatar
RafaelAri
Icon for Helper III rankHelper III
2 years ago
Solved

Select different measures by slicer

Hello to all experts,

I have a Matrix table, containing 16 different columns, each column displays a specific measure, from a Measure-Table.

One of the columns should have the option to display data from 1 of 2 different measures.

How can I use a slicer to select the required measure...

Need Help

4 Replies

  • DataNinja777's avatar
    DataNinja777
    Icon for Super User rankSuper User
    2 years ago

    Hi RafaelAri 

    You can achive your required output by transposing or unpivoting the 16 column measure table, and transform the wide table to a long table like below, and have it as a disconnected table with your fact table, and then use the measure field as the slicer, and write a switch function to link the selected measure to your slicer choice, (or use selectedmeasure function.) 

    Selected Measure = switch(min('Slicer'[#]),1,[Measure A],2,[Measure B],3,[Measure C].... and so on)

     

    # Measure
    1 Measure A
    2 Measure B
    3 Measure C
    4 Measure D
    5 Measure E
    6 Measure F
    7 Measure G
    8 Measure H
    9 Measure I
    10 Measure J
    11 Measure K
    12 Measure L
    13 Measure M
    14 Measure N
    15 Measure O
    16 Measure P

    Best regards,