Forum Discussion

Macks's avatar
Macks
Frequent Visitor
4 years ago
Solved

Comparing a selected Value from one table to All values in another table.

Hi Power Bi community, I am relatively new to Power bi, I feel like this should be simple but i cannot figure it out. Essentially I am trying to compare a single selected value in one table against...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi Macks ,

     

    You can try this expression to reach that.

    check =
IF (
    ISBLANK ( SELECTEDVALUE ( Table1[prices] ) ),
    "Please select one value",
    IF (
        SELECTEDVALUE ( Table2[Thresholds] ) > SELECTEDVALUE ( Table1[prices] ),
        1,
        0
    )
)

     

    Result:

    Pbix in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

     

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

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi Macks ,

 

If you use a calculated column, then there is no way to select threshold. selectedvalue does not make sense when used in a calculated column. Actions at the report level are not fed back to the data table.

 

A workround for selectedvalue() is max(). MAX() is supported for use in DirectQuery.

 

Please share that your pbix file does not contain sensitive information. and the expected results. I apologise as I am not entirely understanding why you need to use related?

 

Best Regards

Community Support Team _ chenwu zhu

 

 

Macks's avatar
Macks
Frequent Visitor
4 years ago

My apologies! i couldnt open the file for some reason so i assumed you created a calculated column but once i was able to open the pbi i realized you made a measure! I marked it as the accepted solution, thank you so much for the help!