Help with DAX to do a lookup based on the measure value

[VJ]

Hi,

I am new to DAX and I am facing  issues writing DAX to do a lookup on a table based on the measure value  and I am not sure if its even possible in power BI.  

My Scenario is I am using an import model in power BI and my source is SQL server i am able to build the measures successfully but when i am trying to compare the  measure value  to reference table and build a measure out of it I am facing the issue i am not able to write DAX to do that. 

Example of what i am trying to accomplish if i have a Average household income of 3.73 my calculation based on the reference table should be like this.

3.73 = 20160+(0.73*4140) 

20160 = householdincome based on lookup for householdsize  of 3 

4140 = step increase basically step increase is difference of amount  (please look at the screen shot below)

Below are some screen shots attached for referece.

your help is greatly appreciated thank you.

[v-sihou-msft · Accepted solution]

 @VJ

You can lookup value based on the result of measure. 

In your scenario, if you want to lookup 3 based on 3.73, you need to ROUNDDOWN() the result from measure. 

Column = LOOKUPVALUE(Table1[result],Table1[Value],ROUNDOWN([Measure],0))

Regards,