Forum Discussion
Rolling average not filtering
Hi all, I created a measure to calculated to conversion rate from free to paying users in our platform. That measure originally is number of paying transitions/number of free transitions. Then I ...
What is the DAX code for your [Free to Paying conversion rate] measure?
(Just FYI, whenever you call a measure within another measure it's implicitly wrapped with CALCULATE. So you don't need to do that manually the way you have it written.)
Thanks for your reply Alexis!
The dax code for that measure is:
Free to Paying conversion rate = [Total Free To Paying Transitions]/[Total Visitor Single Table]
So it's again made up of two measures. Where:
Total Free To Paying Transitions = CALCULATE(
COUNTROWS(Fact_Account_State_Transition),
FILTER(
Fact_Account_State_Transition,
((Fact_Account_State_Transition[TargetAccountStateName] = "Paying")&&(Fact_Account_State_Transition[SourceAccountStateName] = "Free"))
)
)
and
Total Visitor Single Table = COUNTROWS(Fact_Account_State_Transition_Visitor)