Forum Discussion
Field Parameters in Measures
Okay, so this is the base calc :
Measure_to_get_total = CALCULATE ( SUM ( sales_table[Revenue] ), FILTER(sales_table, YEAR( sales_table[date])=2022 and month <= selected month))
Slicer selected : May 2022 (I need to get sum of sales from Jan 2022 to May 2022)
No slicer selected : Current Month (I need to get sum of sales from Jan 2022 to current month)
How can we achieve this with measure? The highlighted red part is what needs to be dynamic.
I tried by using 'selectedvalue' but it does not seem to be working
Anonymous try this calculation, and probably put the year filter in the measure or slicer as you see best fit. The month also you can connect at a slicer level or a MMYYY slicer should also work.
The thing is you don't need to get too attached to the month being a measure. Let the measure be free-flowing then you can control it anyhow.
Cumulative =
CALCULATE (
[Revenue],
FILTER (
ALLSELECTED( 'Date'[Date] ),
'Date'[Date]<= MAX ( 'Date'[Date] ) )
)