cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

## Add maximum values ​​per column

Hi,

In the case of a sale in the amount of U \$ 1000.00, it was received in two times of U \$ 500.00. The information is generated in the table of the SQL database, as shown:

 ID Sale Value Received 1 1.000,00 500,00 1 1.000,00 500,00 2 450,00 225,00 2 450,00 225,00 Total 1.450,00 1.450,00

I need the sum to be performed by a single ID as to the value of the sale and total as to the receipts. I made a few attempts with MAX, but there are problems in the graphics and sums, because it only generates the maximum value.

I need a lot of help.

Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
Member

## Re: Add maximum values ​​per column

Hi Gelain,

have you tried with the FIRSTNONBLANK function:

Sales Value correct sum = SUMX(DISTINCT(Data[ID]), FIRSTNONBLANK(Data[Sales Value], 0))

I got the correct total:

more details:

https://stackoverflow.com/questions/43547620/sum-distinct-values-for-first-occurance-in-power-bi

3 REPLIES 3
Member

## Re: Add maximum values ​​per column

Hi Gelain,

have you tried with the FIRSTNONBLANK function:

Sales Value correct sum = SUMX(DISTINCT(Data[ID]), FIRSTNONBLANK(Data[Sales Value], 0))

I got the correct total:

more details:

https://stackoverflow.com/questions/43547620/sum-distinct-values-for-first-occurance-in-power-bi

Regular Visitor

## Re: Add maximum values ​​per column

Thank you. Helped me a lot.

Community Support Team

## Re: Add maximum values ​​per column

You could use the following measure as well.

```Measure =
SUMX ( VALUES ( Table1[ID] ), CALCULATE ( MAX ( Table1[Sale Value] ) ) )
```
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 266 members 2,920 guests
Recent signins: