Forum Discussion

YeonseokKim's avatar
YeonseokKim
Frequent Visitor
3 years ago
Solved

Averageifs function in Power BI

I want to get average of each category(the category can be changed with filters)   For example, with the date below, I want to get the average pallet # by each loading number.    Please advice m...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Please check the below picture and the attached pbix file.

     

     

    Avg pallets by each loading: = 
AVERAGEX (
    VALUES ( Data[Loading number] ),
    CALCULATE ( SUM ( Data[Pallet #] ) )
)

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

Hi,

Please check the below picture and the attached pbix file.

 

 

Avg pallets by each loading: = 
AVERAGEX (
    VALUES ( Data[Loading number] ),
    CALCULATE ( SUM ( Data[Pallet #] ) )
)