Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 () )
)
User | Count |
---|---|
77 | |
76 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
65 |