Adding Measure? to calculate cumulative values displaying as a %

[Miskondukt]

Good morning,

I think this may be the conversation that drives me to figure out measures. I am trying to get a column to identify the % of "Actual" to "Budget" on the displayed table. Image one is the PBI dashboard and image two is the table I am pulling it from. Looking for direction on either how-to or where to learn how-to. 

Thank you kindly fellow data friends.

Kondukt

[v-yulgu-msft · Accepted solution]

Hi @Miskondukt,

Based on my understanding, your desired output is adding an extra column beside [Budget] to show the percentage value (Actual/Budget), right?

I have uploaded a pbix file (a test based on your sample data) for your reference. Also, you can go through my reply in this thread which described a similar request: Variation estimated vs. real

Best regards,
Yuliana Gu

[Vvelarde]

@Miskondukt

Hi What happen if you use:

%ActualvsBudget=Divide(Sum(Table[Actual]),Sum(Table[Budget]),Blank())

[Miskondukt]

@Vvelarde

This happened: 

When I tried to use it as a "column" as intended: