DAX Formula for Acquisition Rate %

Formula

*Membership Measures'[Acquisition Rate %] = DIVIDE([Actual New Members], [Actual Active Members]) * 100

Explanation

• Functionality: The DIVIDE function calculates the division of two numbers safely, handling cases where the denominator might be zero to prevent errors.
• Parameters:
  • Numerator: [Actual New Members] - This represents the count of new members acquired during a specific period.
  • Denominator: [Actual Active Members] - This is the total number of active members during the same period.
• Multiplication by 100: The result of the division is multiplied by 100 to convert the ratio into a percentage format.

Practical Illustration

Scenario:

Suppose you have the following measures defined in your data model:

• [Actual New Members] = 50
• [Actual Active Members] = 200

Calculation:

1. Division:

   • DIVIDE(50, 200) results in 0.25

2. Convert to Percentage:

   • 0.25 * 100 results in 25

Final Result:

When the formula is executed, the value of *Membership Measures'[Acquisition Rate %] will return 25%, indicating that the acquisition rate of new members is 25%.

Conclusion

This DAX formula effectively measures the acquisition rate as a percentage, providing valuable insights into membership growth. It is crucial for performance analysis and strategic planning within organizations that track membership dynamics. For further mastery of DAX concepts, consider exploring courses offered by the Enterprise DNA Platform.