Sum of measure not adding up

[Qotsa]

Hi,

Trying to get the sum of this measure to total 3 ->

Measure 4 = CALCULATE(DISTINCTCOUNT('powerbi114 view_finance'[client_id]),FILTER('powerbi114 view_finance',SUM('powerbi114 view_finance'[Contract HrsC]) >=50))

I've also tried using SUMX to no avail.

[Qotsa]

@Jihwan_Kim 

That works. Thank you very much.

[Jihwan_Kim · Accepted solution]

Hi, @Qotsa 

Please try to write one more measure like the below, and replace the current one with the below.

NewMeasure Total Fix = SUMX ( VALUES ( [client_id] ), [measure 4] )

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: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM