Forum Discussion

kalpana's avatar
kalpana
Icon for Helper I rankHelper I
9 years ago
Solved

Formula

We want to create average ifs power bi. ho wcan we do this.
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    Generally you do this via something like CALCULATE:

     

    Measure = CALCULATE(AVERAGE([Column]),FILTER(Table,Table[OtherColumn]="Value"))
  • Anonymous's avatar
    Anonymous
    9 years ago

    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's avatar
Baskar
Icon for Resident Rockstar rankResident Rockstar
9 years ago

Do u want average of some value ,

 

create new measure , Measure = Average ( Value )

 

let me know if any help