Forum Discussion

RafaelAri's avatar
RafaelAri
Icon for Helper III rankHelper III
3 years ago
Solved

Current Year and Month sales value

I have a Sales table with "Sale-Value" column and time table, with "Year" & "Month" columns. I need a measure to get the sum of "Sale-Value", in the current Year and Month. Appreciate and thank you...
Tutorial Requests
  • johnt75's avatar
    johnt75
    3 years ago

    You can use

    This month sales =
CALCULATE (
    SUM ( 'Sales'[Sale value] ),
    'Date'[Year] = YEAR ( TODAY () ),
    'Date'[Month] = MONTH ( TODAY () )
)
  • johnt75's avatar
    johnt75
    3 years ago

    You could use REMOVEFILTERS

    This month sales =
CALCULATE (
    SUM ( 'Sales'[Sale value] ),
    'Date'[Year] = YEAR ( TODAY () ),
    'Date'[Month] = MONTH ( TODAY () ),
    REMOVEFILTERS ( 'Date' )
)
RafaelAri's avatar
RafaelAri
Icon for Helper III rankHelper III
3 years ago

Thanx,

I steel have an issue of filtering:

I have some slicers in the visuals page, which filter Year and Month.

"This month sales" is affected by the filtering.

What do I need to add to the DAX code, so the measure will not be filtered?

johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

You could use REMOVEFILTERS

This month sales =
CALCULATE (
    SUM ( 'Sales'[Sale value] ),
    'Date'[Year] = YEAR ( TODAY () ),
    'Date'[Month] = MONTH ( TODAY () ),
    REMOVEFILTERS ( 'Date' )
)