Funnels with cumulative user count

[Anonymous]

Hi All,

i have events dataset (example dataset below)

Using this data set i have to create funnel visulization where i want to see how many users completed the process i.e from Signed up to Field Viewed.

Problem: I have created funnel and added Event in Category and User count in Values, but i am getting entire count of users who have done any of the above event. i want only users who have done all the 3 events i e Signed up,Field Created, Field Viewed 

For Example : 1st bar of funnel should be Total no Users who Signed Up (lets say 100 users signed up)

                       2nd Bar of Funnel should be Total no Users who Created Field out of that 100 users (lets say 75 users created Field)

                       3rd Bar of Funnel should be Total no Users who viewed Field out of that 75 users (lets say 50 users Viewed Field)

I tried to create measure as below but getting blank values

1. 

CALCULATE(DISTINCTCOUNTNOBLANK(Events[user_id]),FILTER(Events,'Events'[event] ="Signed Up" && 'Events'[event] ="Field Created" && 'Events'[event] ="Field Viewed"))

2.  

CALCULATE(DISTINCTCOUNTNOBLANK(Events[user_id]),FILTER(Events,'Events'[event] ="Signed Up") ,FILTER(Events,'Events'[event] ="Field Created"),FILTER(Events,'Events'[event] ="Field Viewed"))

Can you PLease help me to solve this?

Thanks In Advance

Suyog

[Anonymous]

@ryan_mayu 

thank you for your response. it solved my requirement. 

Suyog Ichalakaranji

[ryan_mayu]

you are welcome

[ryan_mayu]

@Anonymous 

pls see the attachment to see if this is what you want

[Anonymous]

Hi @ryan_mayu 

thanks for replying.

My requirement is to see the users who followed process i.e 1st signed up 2nd field created 3rd field viewed.

the users who did first step should only come in 2nd step, same if user has done 1st and 2nd step then only he should come in 3rd step. 

the solution you provided has all the users in 2nd and 3rd bar's. 

[ryan_mayu]

@Anonymous 

pls see the attachment to check if this is what you want

[Anonymous]

Hi @ryan_mayu ,

thank you for reply. it solved the problem for one funnel,

i have requirement for other funnel where i have 6 events which also should follow the same process i. e users who did first step should only come in 2nd step, same if user has done 1st and 2nd step then only he should come in 3rd step , same if user has done 1st,2nd,3rd step then only he should come in 4th step,same if user has done 1st,2nd,3rd,4th step then only he should come in 5th step,same if user has done 1st,2nd,3rd,4th,5th step then only he should come in 6th step.

can you please let me know how to handle this case? 

i tried myself from your inputs in the file could't acheive this.

Thanks in Advance,

Suyog Ichalakaranji

[ryan_mayu]

@Anonymous 

I think the DAX will be more complicated. Please provide the sample data.

[Anonymous]

Hi @ryan_mayu ,

here is sample data,  sorry i am not sure how to attach excel sheet here so pasting the Sample data here.

Event	Event Date	Event id	User id
Signed up	01-05-2022	1	User1
Field Created	01-05-2022	2	User1
Field Viewed	01-05-2022	3	User1
Map Recommended	02-05-2022	4	User1
Map Created	03-05-2022	5	User1
File Exported	04-05-2022	6	User1
PDF Exported	05-05-2022	7	User1
Signed up	01-05-2022	8	User2
Field Created	01-05-2022	9	User2
Field Viewed	01-05-2022	10	User2
Map Recommended	02-05-2022	11	User2
Map Created	03-05-2022	12	User2
File Exported	04-05-2022	13	User2
PDF Exported	05-05-2022	14	User2
Signed up	01-05-2022	15	User3
Field Created	01-05-2022	16	User3
Field Viewed	01-05-2022	17	User3
Map Recommended	02-05-2022	18	User3
Map Created	03-05-2022	19	User3
File Exported	04-05-2022	20	User3
PDF Exported	05-05-2022	21	User3
Signed up	01-05-2022	22	User4
Field Created	01-05-2022	23	User4
Field Viewed	01-05-2022	24	User4
Map Recommended	02-05-2022	25	User4
Map Created	03-05-2022	26	User4
File Exported	04-05-2022	27	User4
PDF Exported	05-05-2022	28	User4
Signed up	01-05-2022	29	User5
Signed up	01-05-2022	30	User6
Field Created	01-05-2022	31	User7
Field Viewed	01-05-2022	32	User7
Map Recommended	02-05-2022	33	User8
Map Created	03-05-2022	34	User8
File Exported	04-05-2022	35	User8
PDF Exported	05-05-2022	36	User8
Field Created	01-05-2022	37	User9
Field Viewed	01-05-2022	38	User9
Field Created	01-05-2022	39	User10
Field Viewed	01-05-2022	40	User11
Map Recommended	02-05-2022	41	User12
Map Recommended	02-05-2022	42	User13
Map Created	03-05-2022	43	User14
Map Created	03-05-2022	44	User15
Signed up	01-05-2022	45	User16
Field Created	01-05-2022	46	User16
Field Viewed	01-05-2022	47	User16
Map Recommended	02-05-2022	48	User16
Map Created	03-05-2022	49	User16
File Exported	04-05-2022	50	User16
PDF Exported	05-05-2022	51	User16
Signed up	01-05-2022	52	User17
Field Created	02-05-2022	53	User17
Field Viewed	03-05-2022	54	User17
Map Recommended	04-05-2022	55	User17
Map Created	05-05-2022	56	User17
File Exported	05-05-2022	57	User17
Signed up	01-05-2022	58	User18
Field Created	02-05-2022	59	User18
Field Viewed	03-05-2022	60	User18
Map Recommended	04-05-2022	61	User18
Map Created	05-05-2022	62	User18
Signed up	01-05-2022	63	User19
Field Created	02-05-2022	64	User19
Field Viewed	01-05-2022	65	User19
Map Recommended	02-05-2022	66	User19

Thanks in Advance

Suyog

[ryan_mayu · Accepted solution]

@Anonymous 

pls see the attachment below