DAX for count of steps in an order

[neelofarshama]

Hi,

I have a column steps which includes data to be counted in an order as shown below. if any one step is missed the count should not take.

STEPS

landingpage

registration_wall

logged_in

payment_details_provided

purchase_submitted

Eg:

Step	User_id
landingpage	1
registration_wall	1
logged_in	1
payment_details_provided	1
purchase_submitted	1
	2
landingpage	2
logged_in	2
payment_details_provided	2
purchase_submitted	2

Expected output: since the step chain of landing page then registration_wall  is not followed in id 2 the count should not be considered.

steps	Output User_id Count
landingpage	2
registration_wall	1
logged_in	1
payment_details_provided	1
purchase_submitted	1

Please help.

Thanks in Advance,

Neelofar.

[v-yetao1-msft]

Hi @neelofarshama 

Is the result you want ?

I got the above result according to your data and SU's method. If this result is what you expect, then the SU‘s method is completely correct . Maybe you can check if there is a problem with the calculation of your check value.

If you can't find the problem, you can provide your pbix file so that we can find the cause of the problem.

Best Regards

Community Support Team _ Ailsa Tao

[Vera_33]

Hi @neelofarshama 

Since you are asking for DAX, so all did in DAX. Not sure why there is a blank step for user_id 2

Hard coded the Index column following the seq of steps, then check column

sum up check column

[neelofarshama]

Hi @Vera_33,

Thank you so much for your reply I tried to implement the same logic in my report but could not get expected results. I created a index column then used check but I am getting all 0. Please help

[Vera_33]

Hi @neelofarshama 

You are using measures in a Table visual, those two columns I created as DAX Calculated column, not measure, so they are showing like this in Table visual. What did you want to achieve?

[neelofarshama]

Hi,

I ried the same logic but no luck below is the link to access my report, hope it helps

https://caltimes-my.sharepoint.com/:u:/g/personal/neelofer_shama_latimes_com/EW7-YOV0DTREm2473VnZEKQ...

[Vera_33 · Accepted solution]

Hi @neelofarshama 

According to your output, I modified your input[check] column, and created a [user_count] measure, here is the output, file attached.