Forum Discussion
ChoiJunghoon
Helper III
Helper III[DAX] How to remove the specific value when i use average?
I want to create the "Average Table " with DAX. how to write the DAX ??
Hi ChoiJunghoon ,
Please create measures like below:
SUM_VALUE = CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[ID]))AVG = var t = FILTER(ALL('Table'[ID]),[SUM_VALUE]>=100) return AVERAGEX(t,CALCULATE(SUM('Table'[Value])))
v-xuding-msft
Community Support
Community SupportHi ChoiJunghoon ,
Please create measures like below:
SUM_VALUE = CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[ID]))AVG =
var t = FILTER(ALL('Table'[ID]),[SUM_VALUE]>=100)
return
AVERAGEX(t,CALCULATE(SUM('Table'[Value])))