Trouble creating a measure to compare values between different columns

[bcoff]

So this measure is designed to grab a pre-prepared measure from a different table and use it to match up with a value in the price column of sheet1 before returning the minimum value corresponding to that price in surcharge. I've made similiar measures in order to get the recent east coast and recent gulf coast correctly but I think i've made a small error somewhere when building this one.

The value in sur is saving and displaying correctly and the MIN function is saving correctly however when I go to add the "Sheet1[Price] = sur" section to the calculate the measure seems to break and just displays a blank on the report. 

I'm rather new to power BI and fabric and dont have a very good idea what I'm doing so any help is greatly appreciated.

[v-zhengdxu-msft · Accepted solution]

Hi @bcoff 

Unfortunately that I can not reproduce your issue.

Given I have so little information at this time, I can't tell what's causing your problem, could you please provide more raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples? It would be helpful to find out the solution. You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

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

[parry2k]

@bcoff Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490