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 same for month and day. Here is an example of the measure I have to calculate the sales in the actual month

 

Can you please give me some help on this? thank you so much

 

 

  • 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.

3 Replies

    • FABIANSMITS's avatar
      FABIANSMITS
      New Member
      3 years ago

      Ashley the measure is Current Month and is calculated this way:

      and the measure for LAST_DATE_SALES is:

       

      And what i want to do is to adjust my measure so that it can calculate the sales per year, month or day as selected

       

  • 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.