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
Super UserHi 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