Im not sure how to display that kind of information in power bi and if powerbi have relevent charts to that kind of information.
I have a data of users and 5 actions they can do in any order they want with the datetime they actually did that
it looks like
User | ActionA | ActionB | ActionC | Action D
111 26/8/18 25/8/18 22/8/18 21/8/18
112 21/8/18 22/8/18 24/8/18 23/8/18
I want to see how the users acts, so I want to know how many went from A>B>C>D and how many A>C>B>D and so on..
More then than, I want to know how many drop in the middle of the proccess, I mean like A>B>DONE(didnt do actions C and D)
In my first topic
@ v-yulgu-msft already helped me with my first issue and I can know how many clients do each order, but not with the second issu
anyone have good advice?
or some other idea how i can display these usfull informaiton?
It seems you may use COUNTROWS Function to get the count of blank date. For example:
Measure = CALCULATE ( COUNTROWS ( Dataset1 ), FILTER ( Dataset1, Dataset1[Date] = BLANK () ) )