Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Sum distinct value based on another column

Hello,
My table follows this structure:

DimenLevel  Quantity
John XXX   15
Alice XXX   15
Lexa XXX   15
Vini YYY   15
Skuerbis YYY   15
Kim ZZZ   5

 

As you can see, the value of the column Quantity is always repeated for each Level. I would like to create a measure that sums only the maximum (or distinct) value of the Quantity column for each Level.

For example:
for the example above, the total sum should be: 35 (15 + 15 + 5)

Can someone help me?

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi, @Anonymous 

Please check the below.

 

Picture3.png

 

 

Total Qty by distinct Level =
VAR grouptable =
GROUPBY (
'Table',
'Table'[Level ],
"@maxqty", MAXX ( CURRENTGROUP (), 'Table'[ Quantity] )
)
RETURN
SUMX ( grouptable, [@maxqty] )

 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

View solution in original post

1 REPLY 1
Jihwan_Kim
Super User
Super User

Hi, @Anonymous 

Please check the below.

 

Picture3.png

 

 

Total Qty by distinct Level =
VAR grouptable =
GROUPBY (
'Table',
'Table'[Level ],
"@maxqty", MAXX ( CURRENTGROUP (), 'Table'[ Quantity] )
)
RETURN
SUMX ( grouptable, [@maxqty] )

 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors