Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
98 | |
89 | |
82 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |