Instead of 5 column how can i retrive when you selected any one total MTD,Total QTD, Total YTD

[MSMKM]

Hi Team,

when i added year wise total --- TotalMTD,TotalQTD, TotalYTD....  my questions below 

1. how we can filter ? if we needed any of TotalMTD,TotalQTD, TotalYTD this ?

Thanks,

Krishna 

[tamerj1 · Accepted solution]

Hi @MSMKM 
One method can be acheived through ustilizing a matrix visual instead of a table. Place the Year column in the rows of the matrix and place the MeasureNames[Measure] column in the columns of the matrix. Then place the proposed measure in the values. (Please refer to attached sample file with the solution).

Measure = 
SWITCH (
    SELECTEDVALUE ( 'MeasureNames'[Measure] ),
    "Total YTD", [Total YTD],
    "Total MTD", [Total MTD],
    "Total QTD", [Total QTD]
)

[MSMKM]

@tamerj1 --- thanks a lot .its working...

[FreemanZ]

hi @MSMKM 

can you elaborate your expectation?

[MSMKM]

Hi FreemanZ,

Recently i have attend an interview in that they are asked a question like below 

If you select any One totalYTD, TotalMTD,TotalQTD, other columns will be hide? how you will do ?