Forum Discussion

owenkosnen's avatar
owenkosnen
Frequent Visitor
4 years ago

Measure cannot be filtered by Date Slicer

Hi,   I have a measure that was created via "New Quick Measure" to calculate the QoQ% Change based on a calculated column (just the total of column A + B + C). I'd like to plot these column and th...
Need Help
Show and Tell
Tips and Tricks
TheoC's avatar
TheoC
Icon for Community Champion rankCommunity Champion
4 years ago

Hi owenkosnen 

 

You can use the following measures:

 

QTD = CALCULATE ( SUM ( Table[Amount] ) , DATESQTD ( 'Date'[Date] ) )

Last QTR = CALCULATE ( SUM ( Table[Amount] ) , DATEADD ( 'Date'[Date] , -1 , Quarter ) )

QoQ% = ( [QTD] - [Last QTR] ) / [Last QTR]

 

Ensure to change the measure [QoQ%] to percentage.

 

Hope this helps.

Theo 🙂

TheoC's avatar
TheoC
Icon for Community Champion rankCommunity Champion
4 years ago

owenkosnen sorry, I had an extra bracket at the end of the QoQ%

 

QoQ% = ( [QTD] - [Last QTR] ) / [Last QTR] 

 

 

 

  • owenkosnen's avatar
    owenkosnen
    Frequent Visitor
    4 years ago

    Yes I also noticed the extra bracket there but seems it is the issue...
    I am ]curious since my base column for (Table[Amount]) is actually a calculated column, could it be the reason why it is not working ?

    • TheoC's avatar
      TheoC
      Icon for Community Champion rankCommunity Champion
      4 years ago

      owenkosnen it is likely to do with the relationship you have. Have you established a relationship between the Date table and Fact table. Have you got a Date column in both the Date table and Fact table?

      • owenkosnen's avatar
        owenkosnen
        Frequent Visitor
        4 years ago

        TheoC there is only one source table for all data so maybe we can opt out relationship setups.. (though I just learned that the best practice should be to keep Date Table separated)