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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
MBrann
Frequent Visitor

Showing the sum of unduplicated values

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

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

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.


Go to My LinkedIn Page


View solution in original post

2 REPLIES 2
Jihwan_Kim
Super User
Super User

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.


Go to My LinkedIn Page


Thank you

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.