Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I need help to solve this:
I have a measure, let say Sales/ Total Sales and I have a disconnected table with percetages and Amounts and I need to get the amount correponding to the percentage calculated,
Ex. Ind Sales/ Total Sales = 95.3%
So In this case I should get 2000
Percentage | Amount |
94% | 1000 |
95% | 2000 |
96% | 3000 |
I tried to use this formula but it's not working:
Solved! Go to Solution.
Hi @leshugaa19 ,
I use the following two tables for testing.
Table1.
Table2.
If you want a calculated column.
Column =
VAR _percentage = ROUNDDOWN('Table1'[Percentage],2)
RETURN
LOOKUPVALUE('Table2'[Amount],'Table2'[Percentage],_percentage)
Or a measure.
Measure 2 =
VAR _percentage = ROUNDDOWN([Measure],2)
RETURN
LOOKUPVALUE('Table2'[Amount],'Table2'[Percentage],_percentage)
Attached PBIX file for reference.
Best Regards,
Community Support Team Gao
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 with it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Thank you, It worked perfectly
Hi @leshugaa19 ,
I use the following two tables for testing.
Table1.
Table2.
If you want a calculated column.
Column =
VAR _percentage = ROUNDDOWN('Table1'[Percentage],2)
RETURN
LOOKUPVALUE('Table2'[Amount],'Table2'[Percentage],_percentage)
Or a measure.
Measure 2 =
VAR _percentage = ROUNDDOWN([Measure],2)
RETURN
LOOKUPVALUE('Table2'[Amount],'Table2'[Percentage],_percentage)
Attached PBIX file for reference.
Best Regards,
Community Support Team Gao
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 with it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
71 | |
43 | |
21 | |
21 | |
14 |
User | Count |
---|---|
125 | |
42 | |
39 | |
28 | |
24 |