count state evolution by date

[gringo89]

Hi,

Firstly, sorry for my english.

We want to restitute the number of document on each status by date.

My fact table likes :

users	Date event	Type event
1	01/03/2020	Sended
1	04/03/2020	Recevied
1	06/03/2020	Integrated
1	06/03/2020	Finished
2	01/03/2020	Sended
2	03/03/2020	Received
3	02/03/2020	Sended
3	10/03/2020	Received
3	11/03/2020	Integrated
3	15/03/2020	Finished
4	05/03/2020	Sended
4	06/03/2020	Received
4	07/03/2020	Integrated

The workflow document is : Sended, received, integrated and finished

i have 3 dimensions : date, user et type event. 

On each date, i want to know the stock on each type event :

Type events	01/03/2020	02/03/2020	03/03/2020	04/03/2020	05/03/2020	06/03/2020	07/03/2020	08/03/2020	09/03/2020	10/03/2020	11/03/2020	12/03/2020	13/03/2020	14/03/2020	15/03/2020
Sended	2	3	2	1	2	1	1	1	1	0	0	0	0	0	0
Received	0	0	1	2	2	2	1	1	1	2	1	1	1	1	1
Integrated	0	0	0	0	0	0	1	1	1	1	2	2	2	2	1
Finish	0	0	0	0	0	1	1	1	1	1	1	1	1	1	2

I want to create a measure but i don't know the dax syntax which can do it.

Thanks for your helps

[az38]

Hi @gringo89 

you dont need DAX for this task

just place fields in the visual as shown below

pay attention - values is Count (Distinct)

pbix-file is attached

[gringo89]

Hi,

thanks for your helps!

This approch can't solve my need. in fact, the 2 march my stock on "sended" type event would be 3 😞

[Anonymous]

Hi @gringo89 ,

Try creating a matrix visual with Type of Event as Rows, Dates as column and USers as Values.

You should be able to get your desired output.

Cheers

CheeenuSing