Forum Discussion

FABIANSMITS's avatar
FABIANSMITS
New Member
3 years ago
Solved

Sales Measure

Greetings PBI Team   I need to calculate the sales according to what is selected in the calendar, for example, if I have selected the year, the sales are calculated based on that selection, and the...
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi FABIANSMITS ,

     

    Please try to add a slicer like this:

    You can achieve your goal by using sum of sales directly:

    Or apply a measure like this:

    Measure = 
var _a = SELECTCOLUMNS('Calendar',"Date",[Date])
return CALCULATE(SUM('Table'[Total Sales]),FILTER(ALL('Calendar'),[Date] in _a))

    Output:

     

     

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

Hi FABIANSMITS ,

 

Please try to add a slicer like this:

You can achieve your goal by using sum of sales directly:

Or apply a measure like this:

Measure = 
var _a = SELECTCOLUMNS('Calendar',"Date",[Date])
return CALCULATE(SUM('Table'[Total Sales]),FILTER(ALL('Calendar'),[Date] in _a))

Output:

 

 

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.