cancel
Showing results for
Did you mean:
Helper II

## Sum of distinct values by customer and Status

I have data like shown below. I want the sum of distinct values by id and status.

 Id Status Amount 1 A 100 1 A 200 1 A 100 1 B 400 1 B 400 1 B 300

I have a filter in my report with status drop down containing A, B etc.

When status A is chosen it should show the output as below

 Id Status Total 1 A 300

when status B is chosen it should show the output as below

 1 B 700

1 ACCEPTED SOLUTION
Super User IV

@bml123

A simple SUM would do:

Total = SUM( Table[Amount])

Did I answer your question? Mark my post as a solution! and hit thumbs up
5 REPLIES 5
Super User IV

@bml123

Create the following measure:

Dis. Total =
SUMX(
DISTINCT(Table[Amount]),
Table[Amount]
)

Did I answer your question? Mark my post as a solution! and hit thumbs up
Helper II

@Fowmy

Hi, thank you. How can we sum the values by id including all the values, not just distinct values?

Super User IV

Not clear, can you show me the expected result based on your sample?

Did I answer your question? Mark my post as a solution! and hit thumbs up
Helper II

Sorry for not being clear.

Expected output for status A should be 400

Expected outout for status B should be 1100

it just need to add all the amounts irrespective if they are same or not.

Super User IV

@bml123

A simple SUM would do:

Total = SUM( Table[Amount])

Did I answer your question? Mark my post as a solution! and hit thumbs up

Announcements

#### 2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

#### Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

#### Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Top Kudoed Authors