[DAX] How to remove the specific value when i use average?

[ChoiJunghoon]

I want to create the "Average Table " with DAX. 

how to write the DAX ?? 

[v-xuding-msft · Accepted solution]

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

 

[amitchandak]

@ChoiJunghoon ,

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