Formula

[kalpana]

We want to create average ifs power bi. ho wcan we do this.

[Greg_Deckler · Accepted solution]

Generally you do this via something like CALCULATE:

Measure = CALCULATE(AVERAGE([Column]),FILTER(Table,Table[OtherColumn]="Value"))

[Anonymous · Accepted solution]

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

[Baskar]

Do u want average of some value ,

create new measure , Measure = Average ( Value )

let me know if any help

[Greg_Deckler · Accepted solution]

Generally you do this via something like CALCULATE:

Measure = CALCULATE(AVERAGE([Column]),FILTER(Table,Table[OtherColumn]="Value"))