Preserving TOTAL

[Sasha]

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

[TomMartens · Accepted solution]

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

[Sasha]

Thank you both!

[LivioLanzo · Accepted solution]

You can do it like this: 

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

[TomMartens · Accepted solution]

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