topic Re: Instead of 5 column how can i retrive when you selected any one total MTD,Total QTD, Total YTD in DAX Commands and Tips

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

MSMKM — Sat, 04 Feb 2023 13:37:57 GMT

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

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

FreemanZ — Sat, 04 Feb 2023 13:57:47 GMT

hi MSMKM

can you elaborate your expectation?

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

MSMKM — Sun, 05 Feb 2023 09:27:43 GMT

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 ?

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

tamerj1 — Sun, 05 Feb 2023 10:34:47 GMT

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] )

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

MSMKM — Mon, 06 Feb 2023 08:46:17 GMT

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