Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter where user enter value

 Hello everyone,   I want create filter where the user enter a value.  For exemple the user enter 7000 and only Machines where the 7000 > MIN and 7000 < MAX are return. (Check picture)   I don't...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi Anonymous 

     

    You could create a measure to filter the table visual. The what-if parameter is to be used in this measure.

    Filter Measure = IF([Trials Value]>SELECTEDVALUE(ChargesOnly[Min])&&[Trials Value]<SELECTEDVALUE(ChargesOnly[Max]),1,0)

     

    Drag the Filter Measure into your table visual's visual-level filter pane and set its value is 1. Then you will find the table visual filtered.

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi Anonymous 

 

Now you have below codes which involves two parameters and two tables. Do you create a relationship between two tables? If not, try creating a relationship based on a common column (maybe Machines or Equipements?) This relationship should be one-to-one so that it can find a specific pair of Min/Max values in FoursOnly table. Or the SELECTEDVALUE(FoursOnly[Min]) might return blank.

 

MachinesOK =
IF([Valeur Force essai] > SELECTEDVALUE(ChargesOnly[Min])
   && [Valeur Force essai] < SELECTEDVALUE(ChargesOnly[Max])
   &&[Valeur Temperature] > SELECTEDVALUE(FoursOnly[Min])
   && [Valeur Temperature] < SELECTEDVALUE(FoursOnly[Max]),
   1,0)

 

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Docs

 

Regards,

Jing