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])))
2 Replies
v-xuding-msftCommunity Support
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
Super User
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])
