Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Switch MTD & YTD visualizing multiple variables

Hi,   I have data for monthly 'Spend amount','Savings amount' and Savings %. The last one is savings amount divided by spend amount. I calculated MTD & YTD figures for all 3 variables. Then I build...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Maybe there is another solution, but I already solved it myself building 3 separate measure selections and putting them in the table or graph.

     

    Measure_Selection_Savings =
    SWITCH( TRUE(),
        VALUES(Slicer_table_savings[Time Cut]) = "MTD", [MTD_savings],
        VALUES(Slicer_table_savings[Time Cut]) = "YTD", [YTD_savings],
        BLANK())
     
    Measure_Selection_Spend =
    SWITCH( TRUE(),
        VALUES(Slicer_table_savings[Time Cut]) = "MTD", [MTD_Spend],
        VALUES(Slicer_table_savings[Time Cut]) = "YTD", [YTD_Spend],
        BLANK())
     
    Measure_Selection_Savings % =
    SWITCH( TRUE(),
        VALUES(Slicer_table_savings[Time Cut]) = "MTD", [MTD_Savings %],
        VALUES(Slicer_table_savings[Time Cut]) = "YTD", [YTD_savings %],
        BLANK())
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi  Anonymous ,

     

    It seems that you have solved by yourself.

     

    Please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

     

    Best Regards,

    Cherry

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Maybe there is another solution, but I already solved it myself building 3 separate measure selections and putting them in the table or graph.

 

Measure_Selection_Savings =
SWITCH( TRUE(),
    VALUES(Slicer_table_savings[Time Cut]) = "MTD", [MTD_savings],
    VALUES(Slicer_table_savings[Time Cut]) = "YTD", [YTD_savings],
    BLANK())
 
Measure_Selection_Spend =
SWITCH( TRUE(),
    VALUES(Slicer_table_savings[Time Cut]) = "MTD", [MTD_Spend],
    VALUES(Slicer_table_savings[Time Cut]) = "YTD", [YTD_Spend],
    BLANK())
 
Measure_Selection_Savings % =
SWITCH( TRUE(),
    VALUES(Slicer_table_savings[Time Cut]) = "MTD", [MTD_Savings %],
    VALUES(Slicer_table_savings[Time Cut]) = "YTD", [YTD_savings %],
    BLANK())
  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    Hi  Anonymous ,

     

    It seems that you have solved by yourself.

     

    Please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

     

    Best Regards,

    Cherry