topic Re: Sales Measure in DAX Commands and Tips

Sales Measure

FABIANSMITS — Mon, 16 Jan 2023 21:06:50 GMT

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

Re: Sales Measure

FreemanZ — Tue, 17 Jan 2023 00:14:53 GMT

hi FABIANSMITS

how is [actual month] defined?

what issue do you have for the mentioned code?

Re: Sales Measure

FABIANSMITS — Tue, 17 Jan 2023 02:31:09 GMT

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

Re: Sales Measure

v-jianboli-msft — Tue, 17 Jan 2023 03:01:50 GMT

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.