Forum Discussion

nitinrungta's avatar
nitinrungta
Frequent Visitor
4 years ago

Field Parameters in Measures

Is there a way to use the Field Parameters in Measures for different calculations?
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 

nitinrungta's avatar
nitinrungta
Frequent Visitor
3 years ago

Anonymous Yeah, Field Parameters might be an easy option but it can be done through measure and a slicer slider also. I have done similar work before. 

Probably it is very easy or I am not understanding it.

But why don't you use a Total YTD function and A slider of Month Numbers? Since it is the month that you are wanting to keep dynamic. And also keep a slicer (or slider) or a year too.