Forum Discussion

Helper III

6 years ago

Solved

[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 ??

6 years ago

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])))

Super User

6 years ago

Try a new table

filter(Summarize(Table, Table[ID],"Sum",sum(Table[Value]) ,"Avg" , Average(Table[Value])),[Sum]>=100)

New Column

AverageX(filter(Summarize(Table, Table[ID],"Sum",sum(Table[Value]) ,"Avg" , Average(Table[Value])),[Sum]>=100),[Avg])