SUMX with filters

[rebeccagref]

Hi! 

I am trying to calculate an avrage for a column. I want to use the sumx since i need an avrage based on 2 questions: 

My current measure looks like this: 

test2 = 

VAR summa_over_medelvarde = SUMX(
    VALUES('team'[RespondID.RespondID Nivå 01]), 
    CALCULATE(
AVERAGEX  ( 'team', 'team'[value] ),'team'[value])
)
var c1 = CALCULATE(
    [utan filter]/2)
    
return IF([utan filter] = 0, c1, summa_over_medelvarde)

Above is the result i'm getting. 
What i want to achive is that if no filter is = 0, then take result/2

let me know if anything other is unclear!!! 🙂 

[v-zhangti]

Hi, @rebeccagref 

Does your sample data look like this?

Measure = SUMX(ALL('Table'),[value])/2

This result is not affected by the filter. Is this the outcome you expect? If not, please let us know the sample data.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.