Forum Discussion
Column in table in model based on filter selection
Is it possible to populate a column in a table in the model (not viz) based on filter/slicer selection?
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 ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Greg_Deckler , has already explained. You can also refer to these
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
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.
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 ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
