Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
RafaelAri
Helper I
Helper I

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 for your help

2 ACCEPTED SOLUTIONS
johnt75
Super User
Super User

You can use

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

View solution in original post

You could use REMOVEFILTERS

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

View solution in original post

3 REPLIES 3
RafaelAri
Helper I
Helper I

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?

You could use REMOVEFILTERS

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

You can use

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.