Forum Discussion
How to Filter with what if ?
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 ...
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] ))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
1 Reply
- Jihwan_Kim
Super User
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] ))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