Forum Discussion
Post PatronDAX-SelectedValue
hi Nimai123
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, you could use a measure with DATEDIFF too, that will give you same result in a visual too.
Regards,
Lin
Post PatronMy calculated Column = SelectedValue(Table[Date])
And I cannot make a measure because I am using this Calculated Column for a DATEDIFF.
Community Supporthi Nimai123
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, you could use a measure with DATEDIFF too, that will give you same result in a visual too.
Regards,
Lin