Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

Reply
MBrann
Frequent Visitor

Showing the sum of unduplicated values

‎12-11-2023 01:06 PM

Hi,

 

I have the below sample of data. If I was to sum the below projects data it would give a value 205. However I only want it to display in a card the sum of just 1 line from each project. (Avg of the rows)... 20+25+40+15 = 100. Can anyone give me a pointer on this please?

ProjectValue
120
120
120
225
225
225
340
415
4

15

Labels:
Message 1 of 3
412 Views
0
1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

‎12-11-2023 01:12 PM

Hi,

Please check the below picture and the attached pbix file.

 

Jihwan_Kim_0-1702329145158.png

 

 

expected result measure: =
SUMX ( VALUES ( Data[Project] ), CALCULATE ( AVERAGE ( Data[Value] ) ) )

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

View solution in original post

MBrann.pbix
Message 2 of 3
397 Views
2 REPLIES 2
Jihwan_Kim
Super User
Super User

‎12-11-2023 01:12 PM

Hi,

Please check the below picture and the attached pbix file.

 

Jihwan_Kim_0-1702329145158.png

 

 

expected result measure: =
SUMX ( VALUES ( Data[Project] ), CALCULATE ( AVERAGE ( Data[Value] ) ) )

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

MBrann.pbix
Message 2 of 3
398 Views
MBrann
Frequent Visitor
In response to Jihwan_Kim

‎12-11-2023 01:22 PM

Thank you

Message 3 of 3
385 Views
0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

Vote for your favorite vizzies from the Power BI World Championship submissions!

Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All