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
Anonymous's avatar
Anonymous
Not applicable
5 years ago

LeaRupnik It would be good if you had given the sample table anyways i hope this will help you

 

you can make use of the below formula

 

Average=calculate(average(sum(salestable[salesunit])))

 


Appreciate your Kudos, Press the thumbs up button!!👍

 

Regards,

Husna

    • 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.