Forum Discussion
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 help.
4 Replies
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
Hello Anonymous and v-alq-msft
in link is an example of what we like to do.
https://drive.google.com/drive/folders/1kNxDiE9t47AH2H7JZuTLLz1USbrCx7kD?usp=sharing
THX
Lea
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.
Hi, LeaRupnik
Based on your description, you may create a measure as below. The pbix file is attached in the end.
Table:
You may create a measure as below.
Result = AVERAGEX( 'Table', 'Table'[Value] )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.
