Forum Discussion

mmanonm's avatar
mmanonm
New Member
9 years ago
Solved

Cumulative percentage problem

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

Reports
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    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

3 Replies

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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's avatar
      mmanonm
      New Member
      9 years ago

      Hi Herbert,

       

      I changed a bit the formula but it works !

      Thanks a lot for your help ! :) 

       

      Best regards, 

       

      Manon