Measure in Page level Filter no way to do calculated column

[yakovlol]

Hello!
I have created WHAT IF parameter on my page. Based on this parameter and value in it  i want to unfilter values on my page.

But it should be dynamically based on what if value, so no way to created a calculated column that would be dynamically changing.

And the measure is really simple it gives me 0 or 1 

var minvalue = min('Parameter'[Parameter])
var maxvalue = max('Parameter'[Parameter])
VAR currentvalue = 
  VALUE([Sales])
return
IF(
    ISBLANK(currentvalue), 
    BLANK(), 
    IF(currentvalue <=  maxvalue, 0, 1)
)

I have more than 8  different visuals on my page, and i want theam all dinamiccaly changing based on parametr, but cannot find a solution to put this filter on Page level

Will be much appriciated for any ideas.

[audreygerred]

Hi! Measures can only be used in visual level filters. They cannot be used in page or all page level: Applying a measure filter in Power BI - SQLBI. In page and all page level, only columns can be used as filters.

[yakovlol]

Thank you @audreygerred But if is there any way to do a calculated column dynamically I mean to make a calculated column based on WHAT IF parameter, or slicer selection?

[Anonymous]

Hi @yakovlol 

In Power BI, calculated columns are static and do not change dynamically based on slicer selections or WHAT IF parameters. 

Best Regards,

Jayleny

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