cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gelain Regular Visitor
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:

 

IDSale ValueReceived
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
pawel1 Member
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:

 

firstnonblank.JPG

more details:

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

3 REPLIES 3
pawel1 Member
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:

 

firstnonblank.JPG

more details:

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

Gelain Regular Visitor
Regular Visitor

Re: Add maximum values ​​per column

Thank you. Helped me a lot.

Community Support Team
Community Support Team

Re: Add maximum values ​​per column

@Gelain,

 

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.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 343 members 3,594 guests
Please welcome our newest community members: