Forum Discussion

Sasha's avatar
Sasha
Helper III
7 years ago
Solved

Preserving TOTAL

Hi,

assume I have two customers:

Customer A paid $100

Customer B paid $50

 

I would like to show top 1 customer by paymnet.

Choosing the correct filter I get

Customer Payment 

A               $100

Total         $100

 

How can I show an extra column with % of total payment, equaling to 0.66 (100/150).

In other words - I would like to define a measure that is always equals to sum of both payments, regardless of the filter. 

Thank you in advance,

Alex

Need Help
  • TomMartens's avatar
    TomMartens
    7 years ago

    Hey,

     

    this measure creates what you are looking for

    Payment vs Payment All = 
var currentPayment = CALCULATE(SUM('Table1'[Payment]))
var AllPayment = CALCULATE(SUM('Table1'[Payment]),ALL('Table1'[Customer]))
return
DIVIDE(currentPayment, AllPayment, BLANK())

    and a little screenshot:

    Hopefully this provides what you are looking for.

     

    Regards,

    Tom

     

  • LivioLanzo's avatar
    LivioLanzo
    7 years ago

    You can do it like this: 

     

    =DIVIDE( SUM( Data[Amount] ), CALCULATE( SUM( Data[Amount] ), ALL( Data[Customer] ) ) )

     

3 Replies

  • TomMartens's avatar
    TomMartens
    Super User
    7 years ago

    Hey,

     

    this measure creates what you are looking for

    Payment vs Payment All = 
var currentPayment = CALCULATE(SUM('Table1'[Payment]))
var AllPayment = CALCULATE(SUM('Table1'[Payment]),ALL('Table1'[Customer]))
return
DIVIDE(currentPayment, AllPayment, BLANK())

    and a little screenshot:

    Hopefully this provides what you are looking for.

     

    Regards,

    Tom

     

  • LivioLanzo's avatar
    LivioLanzo
    Solution Sage
    7 years ago

    You can do it like this: 

     

    =DIVIDE( SUM( Data[Amount] ), CALCULATE( SUM( Data[Amount] ), ALL( Data[Customer] ) ) )