Forum Discussion
% from previous step
Hello, I'm looking for a way to calculate % from previous step. My table has data for each week. Here's an example of how it is structured for any given week: I'm ...
With my initial stab at it % from previous, I had some trouble. I was able to get "% of max" to work using a different method:
Measures:
Step Value = CALCULATE(SUM('Conversion Funnel'[Visits]))
Sum of All Visits =
CALCULATE(
SUM('Conversion Funnel'[Visits]),
'Conversion Funnel'[Steps] IN { "All Visits" }
)
% of All Visits = Divide([Step Value],[Sum of All Visits])
