Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to Solution.
You can use
This month sales =
CALCULATE (
SUM ( 'Sales'[Sale value] ),
'Date'[Year] = YEAR ( TODAY () ),
'Date'[Month] = MONTH ( TODAY () )
)
You could use REMOVEFILTERS
This month sales =
CALCULATE (
SUM ( 'Sales'[Sale value] ),
'Date'[Year] = YEAR ( TODAY () ),
'Date'[Month] = MONTH ( TODAY () ),
REMOVEFILTERS ( 'Date' )
)
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' )
)
You can use
This month sales =
CALCULATE (
SUM ( 'Sales'[Sale value] ),
'Date'[Year] = YEAR ( TODAY () ),
'Date'[Month] = MONTH ( TODAY () )
)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
129 | |
78 | |
76 | |
60 | |
53 |
User | Count |
---|---|
164 | |
86 | |
68 | |
68 | |
58 |