Forum Discussion
Solved
Formula
We want to create average ifs power bi. ho wcan we do this.
Generally you do this via something like CALCULATE:
Measure = CALCULATE(AVERAGE([Column]),FILTER(Table,Table[OtherColumn]="Value"))
Hi kalpana,
smoupre's formula seems well, you can also use the averagex function to achieve your requirement.
Sample:
Measure = AVERAGEX(FILTER(ALL(Sheet1),[ConditionColumn]="Value"),[Amount])
Regards,
Xiaoxin Sheng
3 Replies
Generally you do this via something like CALCULATE:
Measure = CALCULATE(AVERAGE([Column]),FILTER(Table,Table[OtherColumn]="Value"))
Do u want average of some value ,
create new measure , Measure = Average ( Value )
let me know if any help
Hi kalpana,
smoupre's formula seems well, you can also use the averagex function to achieve your requirement.
Sample:
Measure = AVERAGEX(FILTER(ALL(Sheet1),[ConditionColumn]="Value"),[Amount])
Regards,
Xiaoxin Sheng
