Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Dynamic Measures based on filter selection

I have Sales Column and I created a YTD measure using that column. I want to accomplish the following.   Show YTD or Sum of Sales when a date value is selected. Is there a way to accomplish this, l...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Anonymous

     

    1. Create a New Table with

     

    Calc

    YTD

    Monthly

     

    2. Then Use a Slicer with this column

     

    3. Create a measure

     

    Sales=Switch(Values(Newtable[Calc]),"YTD",MeasureofYTD,"Monthly",MeasureofSumSales)

     

     

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

Anonymous

 

1. Create a New Table with

 

Calc

YTD

Monthly

 

2. Then Use a Slicer with this column

 

3. Create a measure

 

Sales=Switch(Values(Newtable[Calc]),"YTD",MeasureofYTD,"Monthly",MeasureofSumSales)