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...
  • Vvelarde's avatar
    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)