Measure as a filter

[fabianfilth]

Hello pbi community

I hope you can help me with this question.

Is there any possibility to take a dax measure into a visual filter? or how can I achieve this?

Thanks in advance

[DallasBaba]

@fabianfilth you cannot directly use a DAX measure in a visual filter.
But you can achieve a similar result by creating a calculated column replicating the DAX measure's logic and then using that column as a visual filter.

By creating a calculated column, you effectively store the DAX measure's results in a new column in your data model, which can then be used as a filter in visuals.

Note:
Calculated columns use storage space and are pre-calculated during data refresh, so you should be cautious when using them, especially with large datasets.

Reference for more info:
https://www.sqlbi.com/articles/deep-dive-into-measure-filters-in-power-bi-desktop/

https://community.fabric.microsoft.com/t5/Desktop/How-to-to-use-a-measure-as-a-filter-in-DAX/m-p/597...

Please let me know if this works

Thanks