Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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,
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |