Averageifs function in Power BI

Question

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 me that how to get the average by each loading number.

*Condition

1) All pallets with same loading number must be combined

2) All data must be calculated with each loading number.

In excel, I can get the data by converting below data to pivot tabel.

And then, I can get the data by using simple average function.

But, I want to establish it in power bi automatically.

Many thanks

jihwan_kim · Accepted Answer

Hi,
Please check the below picture and the attached pbix file.
&nbsp;

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

Forum Discussion