Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Static Baseline

I'm trying to use the average of the Jan 2020 and Feb 2020 Units Sold per work day as a baseline to compare to the COVID Months.   I have a reporting period month table and a sales table.    To c...
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , you have to use all or allselected to make sure you get a value when month is in context

     

    Jan Work Days = CALCULATE(sum('Monthly_Reporting_Period'[Period_Workday_Cnt]), filter(all('Monthly_Reporting_Period'),'Monthly_Reporting_Period'[Month_Year_Abbr]="Jan 2020"))

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , you have to use all or allselected to make sure you get a value when month is in context

 

Jan Work Days = CALCULATE(sum('Monthly_Reporting_Period'[Period_Workday_Cnt]), filter(all('Monthly_Reporting_Period'),'Monthly_Reporting_Period'[Month_Year_Abbr]="Jan 2020"))