Forum Discussion
Need Help Averaging a Measure Derived from Two Other Measures
Hello AnjaliChettiar
Try with AverageX
Avg Derived Measure =
AVERAGEX (
VALUES ( Dealer[Dealer Name] ),
[Derived Measure]
)
If my response helped you, please consider clicking
Accept as Solution ✅ and giving it a Like 👍 – it helps others in the community too.
Thanks,
Connect with me on:
LinkedInHi AnjaliChettiar ,
pankajnamekar25 offered you a solution with AVERAGEX, that works but it does not take into account blanks in the average calculation. if that is fine w/you, that is your solution. Otherwise if you need to take into account of blanks, consider this
DIVIDE (
SUMX ( VALUES ( Dealer[Dealer Name] ), [Derived Measure] ),
COUNTROWS ( VALUES ( Dealer[Dealer Name] ) )
)If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Hi AnjaliChettiar ,
Thank you pankajnamekar25 for the response provided!
Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.
Thank you.
Hi AnjaliChettiar ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.