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.
Hello all, I have a single table with two columns, Estimated Revenue and Actual Revenue. I'm looking to find what percent Estimated Revinue is of Actaul Revenue. For example if Estimated Revenue is 300 and Actual Revenue is 10 then Percent = 3. Not sure how to do this as you'd have to move the decimal over 2 spaces after dividing. Any help is greatly appreiciated. My goal is to add color saturation to a tree map, the closer to 0% the more red, the closer to 100% the more green etc. Thanks everyone.
Solved! Go to Solution.
Hi @ajnunezjr,
Based on my test, you could refer to below formula:
Measure = DIVIDE(CALCULATE(SUM(Table1[Projected value])),CALCULATE(SUM(Table1[Actual value])))
Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
In the example you give, 300/10 = 30, which as a percentage would be 3000%. Are you sure that's what you want?
In any case, once you create the calculated column (or measure), you can set it to format "Percentage" on the Modelling tab. It will display as a percentage such as 99.75%
Hope this helps
David
Thanks @dedelman_clng, but I may not be clear with what I'm asking for. I've attached my sample query below. But my goal is to create the measure to show me what percent "Projected Revenue" is of "Actual Value". So if in Projected Value is 10 and Actual is 100 my new column should read 10%.
Hi @ajnunezjr,
Based on my test, you could refer to below formula:
Measure = DIVIDE(CALCULATE(SUM(Table1[Projected value])),CALCULATE(SUM(Table1[Actual value])))
Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |