Cumulative percentage problem

[mmanonm]

Hi all, 

I need your help please.

I have a big table with several lines with percentages. For one topic, I want to get the global percentage but POWER BI gives me the cumulative percentage (I think), even when I change the data format. 

For example:

SUPPLIER 1

Booked quantity = 966 UNT

Consummed quantity = 1402 UNT

Difference between both criteria = 436 UNT 

So the difference in percentage is 45% 

But when I put this data in POWER BI, the total percentage I got is 160% even if I don't ask for SUM.

Do you know how can I do to correct this? 

Thanks a lot for your help.

Manon

[v-haibl-msft · Accepted solution]

@mmanonm

If Booked quantity and Consummed quantity are two columns in one table, you can create a measure like the formula below, and put it in the Card visual to show the result.

Measure = 
ABS (
    DIVIDE (
        SUM ( 'SUPPLIER 1'[Booked quantity] ) - SUM ( 'SUPPLIER 1'[Consummed quantity] ),
        SUM ( 'SUPPLIER 1'[Booked quantity] )
    )
)

Best Regards,
Herbert

[mmanonm]

Hi Herbert,

I changed a bit the formula but it works !

Thanks a lot for your help ! 🙂 

Best regards, 

Manon

[v-haibl-msft]

@mmanonm

Please let me know if it works for you.

Best Regards,
Herbert