distinct count

[MSAYED26]

Hello ,

I want to count how many parts with supplier more than 2 and supplier equal 1

Part	Supplier
W0030508752R	A
W0030508752R	B
W0030509095H-V1	A
W0030509095H-V1	A
W0030509095H-V1	B
W41013044	C
W41013621	C
W41017168	C
W41017173	C
W41018408	C
W41018445	C

I have done this measure
 Count Supplier = CALCULATE(DISTINCTCOUNT('Table'[Supplier]),ALLEXCEPT('Table','Table'[Part]))
More than 2 = CALCULATE(DISTINCTCOUNT('Table'[Part]),FILTER(ALL('Table'),[Count Supplier]>=2))
Equal 1 = CALCULATE(DISTINCTCOUNT('Table'[Part]),FILTER(ALL('Table'),[Count Supplier]=1))
but the value is fixed with date . How can I make it change from date ?

[MSAYED26]

Thanks for the advice,

Part	Supplier
W0030508752R	A
W0030508752R	B
W0030509095H-V1	A
W0030509095H-V1	A
W0030509095H-V1	B
W41013044	C
W41013621	C
W41017168	C
W41017173	C
W41018408	C
W41018445	C

I want to count how many parts with supplier more than 2 and supplier equal 1  and change with date

In this example I have the count  of parts that have more than or equal 2 supplier is 5 parts and the count of parts that have one supplier is 6 parts 

[lbendlin]

Your sample data does not include dates.  That means we cannot comment on the requirement 

I want to count how many parts with supplier more than 2 and supplier equal 1  and change with date

[MSAYED26]

Parts	Posting Date	Suppliers
W8TC1806100C	05-01-2020	A
W43002256AC	08-01-2020	B
W63X54HL	08-01-2020	B
W41018395	12-01-2020	E
W43011994S	12-01-2020	E
W43016101S	12-01-2020	E
W91104433S	12-01-2020	E
W43002256	14-01-2020	B
W43002256AC	14-01-2020	B

[lbendlin]

your sample data is insufficient to cover your scenarios.

[MSAYED26]

Material	Posting Date	Suppliers
W8TC1806100C	05-01-2020	A
W43002256AC	08-01-2020	B
W63X54HL	08-01-2020	B
W41018395	12-01-2020	E
W43011994S	12-01-2020	E
W43016101S	12-01-2020	E
W91104433S	12-01-2020	E
W43002256	14-01-2020	B
W43002256AC	14-01-2020	B
W41018395	14-01-2020	E
W43011994S	14-01-2020	E
W43016101S	14-01-2020	E
W91104433S	14-01-2020	E
W41018395	18-01-2020	E
W43011994S	18-01-2020	E
W43016101S	18-01-2020	E
W91104433S	18-01-2020	E
W430117AC3S	20-01-2020	D
W430117C3S	20-01-2020	D
W430117DC3S	20-01-2020	D
W430317AC3S	20-01-2020	D
W430317C3S	20-01-2020	D
W430317DC3S	20-01-2020	D
W430517C3	20-01-2020	D
WC7S100X75	20-01-2020	D
WH7S100X75	20-01-2020	D
WH8S100X75	20-01-2020	D
W43000493	20-01-2020	G
W43000505	20-01-2020	G
W8TC1806100C	21-01-2020	A
W41018395	21-01-2020	E
W43011994S	21-01-2020	E
W43016101S	21-01-2020	E
W91104433S	21-01-2020	E
W41018395	23-01-2020	E
W43011994S	23-01-2020	E
W43016101S	23-01-2020	E
W91104433S	23-01-2020	E
W0030509095H	25-01-2020	B
W41018395	26-01-2020	E
W43011994S	26-01-2020	E
W43016101S	26-01-2020	E
W91104433S	26-01-2020	E
W43000493	26-01-2020	G
W0030509095H	28-01-2020	B
W63280Z12DNE	28-01-2020	B
W63X54HL	28-01-2020	B
W43002256	30-01-2020	B
W43002256AC	30-01-2020	B
W43000493	30-01-2020	G
W43000493	03-02-2020	G
W43002256	04-02-2020	B
W430117AC3S	04-02-2020	D
W430117C3S	04-02-2020	D
W430117DC3S	04-02-2020	D
W430317C3S	04-02-2020	D
W430317DC3S	04-02-2020	D
W43000493	06-02-2020	G
W43000493	06-02-2020	G
W0030508752R	07-02-2020	B
W63280Z07DNE	07-02-2020	B
W63280Z10DNE	07-02-2020	B
W41018395	10-02-2020	E
W43011994S	10-02-2020	E
W43016101S	10-02-2020	E
W91104433S	10-02-2020	E
41043465H	10-02-2020	H
W20180227	10-02-2020	H
W21448072	10-02-2020	H
W41008862	10-02-2020	H
W41013621	10-02-2020	H
W41013814	10-02-2020	H
W41017168	10-02-2020	H
W41017173	10-02-2020	H
W41018408	10-02-2020	H
W41018445	10-02-2020	H
W41019104	10-02-2020	H
W41021016	10-02-2020	H
W41021255	10-02-2020	H
W41021741	10-02-2020	H
W41021829	10-02-2020	H
W41021881	10-02-2020	H
W41021976	10-02-2020	H
W41021980	10-02-2020	H
W41022049	10-02-2020	H
W41022300	10-02-2020	H
W41023685	10-02-2020	H
W41024476	10-02-2020	H
W41026473	10-02-2020	H
W41027093	10-02-2020	H
W41033254	10-02-2020	H
W41034869	10-02-2020	H
W41036197	10-02-2020	H
W41037571	10-02-2020	H
W41038265	10-02-2020	H
W41039460	10-02-2020	H
W41040031	10-02-2020	H
W41040283	10-02-2020	H
W41040979	10-02-2020	H
W41040994	10-02-2020	H
W41041005	10-02-2020	H
W41041367	10-02-2020	H
W41041369	10-02-2020	H
W41041380	10-02-2020	H
W41041381	10-02-2020	H
W41041608	10-02-2020	H
W41042533	10-02-2020	H
W41042893	10-02-2020	H
W41042927	10-02-2020	H
W41043962	10-02-2020	H
W41044550	10-02-2020	H
W41045967	10-02-2020	H
W41048221	10-02-2020	H
W41048222	10-02-2020	H
W43000134	10-02-2020	H
W43005378	10-02-2020	H
W43005963	10-02-2020	H
W43008783	10-02-2020	H
W43010381	10-02-2020	H
W43010993	10-02-2020	H
W43012569	10-02-2020	H
W43017575	10-02-2020	H
W43020080	10-02-2020	H
W43020091	10-02-2020	H
W43023852	10-02-2020	H
W43025155	10-02-2020	H
W46006726	10-02-2020	H
W90319302	10-02-2020	H
W90467903	10-02-2020	H
W91200193	10-02-2020	H
W91400204	10-02-2020	H
W91408004	10-02-2020	H
W91408008	10-02-2020	H
W91602887	10-02-2020	H
W91602948	10-02-2020	H
W92250869	10-02-2020	H
W92412188	10-02-2020	H

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely. Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...