Sum total not correct on measure on measure

[NeilMaharaj]

I have a multiple tables where i have used [user id] and then used measures to calculate a [pipeline value]. I have then another measure that highlights the variance between the [pipeline value] and [target] to give me a variance measure [Var v Target].

In addition, i have create a flag [FlagMeasure], where  = IF([Var v Target]>0,1,0).

Now when i want to sum the total of [FlagMeasure] it just gives me 1. Where what i want is to sum all the 1's in the range. Below example should give me 6 as the total.

therefore summing a measure on a measure

[parry2k]

@NeilMaharaj seems like a duplicate post. 

[amitchandak · Accepted solution]

@NeilMaharaj , Try like

sumx(summarize(table,table[userID],"_1",[Var v Target]), IF([_1]>0,1,0))

[NeilMaharaj]

Awesome! This worked well and will be useful for some other reports i am doing.