Divide with error in total - Measure

[Anonymous]

Hello everyone,

I would like to have the correct total result of dividing the Value / Goal_Sum columns. (Goal_Percent_Of_Value)

In the base structure, the Goal value is repeated, as there is a value per month for each type (Type column).

In the table, the goal column is composed of two measures as shown in the images below for sum.

The column for dividing the amount by goal is a measure.

The correct thing is that the division also works in the total values, as calculated in excel for example.

Here is the pbix file for verification. HERE

Regards,
Bruno

[Anonymous]

hI @Fowmy,

This worked perfectly. Thanks for the support!

Regards,
Bruno

[Fowmy · Accepted solution]

@Anonymous 

You need to modify your formula as follows:

Goal_Percent_Of_Value = Divide( SUM(Data[Value]) , [Goal_Sum] )

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn