How to Filter with what if ?

[Anonymous]

Hello everyone,

I have a problem ... I would like filter my table with a what if. I explain problem.

If user enter 3540 in the "what if" only Machines where Min < what if > Max are return.

I don't know if the fonctonality exist.

Help me ...

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

I am not sure if I understood your question correctly, but please check the below picture and the sample pbix file's link down below. I tried to create the sample pbix file based on the explanation.

Max Measure =

IF (

SELECTEDVALUE ( 'Table'[Min] ) <= SELECTEDVALUE ( Parameter[Parameter] )

&& SELECTEDVALUE ( 'Table'[Max] ) >= SELECTEDVALUE ( Parameter[Parameter] ),

SELECTEDVALUE ( 'Table'[Max] )

)

https://www.dropbox.com/s/rbh31bif6mwyclv/mateo.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM