Distinct number of orders per year

Mederic — Tue, 21 Mar 2023 21:57:58 GMT

Hello everyone,

I have a data table in which I would like to count the number of distinct orders.
I have integrated my source into Power Pivot and selected the option "Distinct Count"

But it doesn't work. I would like to have the result in the table in green (see picture)
Do I need to go through a measure and if so which one?

Thank you in advance for your help

Regards

POPOSTEDate PONameAmountCategorie

8900015	1	21/03/2021	ABC	43	A
8900015	2	21/03/2021	ABC	64	A
8900019	1	17/05/2021	DEF	32	B
8900019	2	17/05/2021	DEF	-14	B
8900019	3	17/05/2021	DEF	16	B
8900019	4	17/05/2021	DEF	42	B
8900027	1	01/10/2022	GHI	34	A
8900027	2	01/10/2022	GHI	78	A
8900028	1	12/11/2022	JKL	120	A
8900028	2	12/11/2022	JKL	12	A
8900028	3	12/11/2022	JKL	-36	A
8900028	4	12/11/2022	JKL	-65	A
8900032	1	15/12/2022	MNO	67	B
8900056	1	13/01/2023	OPQ	135	B
8900056	2	13/01/2023	OPQ	24	B
8900078	1	18/02/2023	RST	78	A
8900078	2	18/02/2023	RST	-15	A
8900078	3	18/02/2023	RST	44	A

Re: Distinct number of orders per year

wdx223_Daniel — Wed, 22 Mar 2023 01:29:08 GMT

you need to create a mearsure

=DISTINCTCOUNT(Table[PO])

Re: Distinct number of orders per year

Mederic — Wed, 22 Mar 2023 06:11:56 GMT

Hello wdx223_Daniel ,
As simple as that, thank you very much, it works very well,

Have a nice day

topic Re: Distinct number of orders per year in DAX Commands and Tips

Distinct number of orders per year

Re: Distinct number of orders per year

Re: Distinct number of orders per year