Column in table in model based on filter selection

[Anonymous]

Is it possible to populate a column in a table in the model (not viz) based on filter/slicer selection?

[dax · Accepted solution]

Hi @Anonymous , 

As mentioned above, we couldn't use slicer and filter to control the calculated column, this will affect the measure and visual. If you want to dynamic filter the data in model, I think you could use parameter in model. You could refer to using-parameters-in-power-bi  and deep-dive-into-query-parameters-and-power-bi-templates  for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Greg_Deckler , has already explained. You can also refer to these

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

https://www.youtube.com/watch?v=SVEGfqCTodc

[Greg_Deckler]

No, and the reason is that tables and columns are calculated at the time of data load. Thus, after data load they are static and not dynamic based upon user interactions. You could however create a measure that created a dynamic table variable using VAR that was based upon that slicer selection and then use it in some manner.