Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Visualization: YTD target vs YTD actual

I've got a table with dates and sales, it's connected to CRM online which will be auto refreshed.   i've created a "Gauge" dashboard with Max (Year Target) and Target (YTD Target)   t...
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
9 years ago

Hi Anonymous, you could possibly create another Calculated Measure which will can then use a filter.


EG: 

Todays Total = CALCULATE([My measure],Filter('Dates','Dates'[Calendar Date] = NOW()))
Anonymous's avatar
Anonymous
Not applicable
9 years ago

GilbertQ what's the expression should after "totalytd"?  thanks. 

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    9 years ago

    Hi there I think it should be the following:

     

    YTDBudgetRev = TOTALYTD([SumNet],'CalendarDate'[Date],ALL('CalendarDate'),"29/01")
    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      GilbertQthis is what i've got, but didn't bring correct value. 

       

      • GilbertQ's avatar
        GilbertQ
        Icon for Super User rankSuper User
        9 years ago

        Hi Anonymous, could you remove the (Budgets[BudgetRev]) from your calculation and see if that works?