Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

User Input is not recognized in DAX formula

Hi all,   I am a newbie and want to create a report with different sets of criteria, based on user input. The input value appear fine on the dashboard and in the report table but in formulas, it se...
General Comment
Need Help
Tips and Tricks
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

Calculated columns cannot be responsive to user interactions like slicers. This is because they are calculated only once per time the data model is loaded or refreshed rather than in response to slicers. Once the model is loaded, they are fixed.

 

Measures, on the other hand, are intended to be dynamic and responsive to interactions. SELECTEDVALUE ( ... ) works just fine with measures.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Alexis,

 

You are right on both counts. I misstated earlier about the column, the Mon_Num_Ref is actually a measure that looks at the SelectedValue of the slicer.

And it works correctly with every change in selected input value.

 

The Report Amount is a new column. It only works correctly with hard-coded values such as 3 and it works correctly with the original columns of Query1. But it ignores the new measures that I defined such as Mon_Num_Ref.