Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
The table A above has a column called range, and the table B has a weight value column.
This weight value is 420, so it belongs to less than 500 and greater than 0. So I want to get the corresponding rate value in the end which is 14.84 in this case.. how can I sort this out..?
Solved! Go to Solution.
Hi @BrianLee ,
Please create a new calculated column:
state_id =
CALCULATE (
MAX ( 'TableA'[rate] ),
FILTER ( ALL ( 'TableA' ), 'TableA'[Range] < 'TableB'[Weight] )
)
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi @BrianLee ,
Please create a new calculated column:
state_id =
CALCULATE (
MAX ( 'TableA'[rate] ),
FILTER ( ALL ( 'TableA' ), 'TableA'[Range] < 'TableB'[Weight] )
)
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
User | Count |
---|---|
21 | |
20 | |
13 | |
10 | |
8 |
User | Count |
---|---|
30 | |
28 | |
13 | |
12 | |
11 |