Column A is what percent of Column B measure

[ajnunezjr]

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.

[dedelman_clng]

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

[ajnunezjr]

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%.

[v-danhe-msft · Accepted 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