Forum Discussion

LeaRupnik's avatar
LeaRupnik
Icon for Helper III rankHelper III
5 years ago

Avrege with filters

Hello,    I'm new in Dax formula, a would like to ask how to calculate an average with a filter.  In Power BI a get a value of 1,251 in excel is this value a 1,267. what I do wrong.    Please he...
Need Help
v-alq-msft's avatar
v-alq-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, LeaRupnik 

 

I am sorry for the late reply. I modified data based on your sample data. The pbix file is attached in the end. You may create a measure as below.

Measure = 
AVERAGEX(
    SUMMARIZE(
        List1,
        List1[Column1],
        "Result",
        AVERAGE(List1[Column2])
    ),
    [Result]
)

 

Result:

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.