Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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