Forum Discussion
Column Calculated using Slider Input
Community Supporthi adriankelly
First, you should know that:
1. Calculation column/table not support dynamic changed based on filter or slicer.
2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary result in a visual.
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
Second, for your case, you just could just create a simple measure as below:
Y = SUM('Table'[X]) - 'Parameter'[Value]
And then drag this measure into visual.
and here is sample pbix file, please try it.
Regards,
Lin
Hi v-lili6-msft,
Thanks for your response.
The sample file contained what I was looking for.
Coming from an excel background the DAX language and operation is a bit confusing .
Is the Y measure below storing the results in an array?
- v-lili6-msft
hi adriankelly
No, measure will calculate by it row context in a visual. It likes you define a function, then call it by row text in a visual.
Regards,
Lin
Thanks for your help.