cancel
Showing results for
Did you mean:
Member

## 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.

Alex

2 ACCEPTED SOLUTIONS

Accepted Solutions
MVP

## Re: Preserving TOTAL

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

Hamburg - Germany
I accept Kudos :-), If you find my post helpful.

Proud to be a Datanaut!
Super Contributor

## Re: Preserving TOTAL

You can do it like this:

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

Proud to be a Datanaut!

3 REPLIES 3
MVP

## Re: Preserving TOTAL

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

Hamburg - Germany
I accept Kudos :-), If you find my post helpful.

Proud to be a Datanaut!
Super Contributor

## Re: Preserving TOTAL

You can do it like this:

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

Proud to be a Datanaut!

Member

## Re: Preserving TOTAL

Thank you both!

Announcements

Kudos to you if you earned one of these! Check your inbox for a notification.

#### Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

#### Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (2,001)