Forum Discussion
Dax change help needed.
Hey guys,
Could help me replace the average with the new measure in bold?
Bud_NetChurn_Var = [Net Churn Monthly % - 30D] - AVERAGE('Budget_6+6_2022'[Churn %])
Instead of using this 'Budget_6+6_2022'[Churn %], I need to use this Net Churn Budget%
Net Churn Budget% = DIVIDE([BudgetChurn], [Budgeted_Opening_Base])
Because it's a measure, I'm strugling to get the average. What do I need to do here?
Many thanks! 🙂
1 Reply
Hi ROG ,
Based on your description, do you want to calculate the average of the measure [Net Churn Budget%]?
Please try this:
Average of measure = AVERAGEX(VALUES(Table[Column]),[Net Churn Budget%])Table[column] depends on your needs, you can refer to the solution in the following post for more information:
Calculating average of a measure - Microsoft Power BI Community
calculate average of a measure - Microsoft Power BI Community
powerbi - How to get average from a measure in Power BI desktop - Stack Overflow
Best Regards,
Neeko Tang
If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.
