Forum Discussion

Hactogeek's avatar
Hactogeek
Frequent Visitor
8 years ago

Calculated Column with filter on selected values

Hi everyone,   I need to update my calculated column values based on user selections in the report.   I tried a lot of DAX formula but no way to reach my goal.   My DAX formula :     Colonne...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi Hactogeek,

 

As a general suggestion, you may should try ALLSELECTED(InLaneEvents[Id]) Instead of ALLSELECTED(InLaneEvents) because there're some difference between them.  ALLSELECTED(InLaneEvents) will remove all the filters in table InLaneEvents while ALLSELECTED(InLaneEvents[Id]) only remove the column filter.  For details, please also refer to: https://www.sqlbi.com/articles/understanding-allselected/.

 

Regards,
Jimmy Tao