distinct count

Question

Hello ,I want to count how many parts with supplier more than 2 and supplier equal 1Part&nbsp;SupplierW0030508752RAW0030508752RBW0030509095H-V1AW0030509095H-V1AW0030509095H-V1BW41013044CW41013621CW41017168CW41017173CW41018408CW41018445CI&nbsp;have done this measure&nbsp;Count Supplier = CALCULATE(DISTINCTCOUNT('Table'[Supplier]),ALLEXCEPT('Table','Table'[Part]))More than 2 = CALCULATE(DISTINCTCOUNT('Table'[Part]),FILTER(ALL('Table'),[Count Supplier]&gt;=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 ?&nbsp;&nbsp;

lbendlin · Answer

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-Forum/ba-p/963216
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/1447523

msayed26 · Answer

Thanks for the advice,Part&nbsp;SupplierW0030508752RAW0030508752RBW0030509095H-V1AW0030509095H-V1AW0030509095H-V1BW41013044CW41013621CW41017168CW41017173CW41018408CW41018445CI want to count how many parts with supplier more than 2 and supplier equal 1&nbsp; and change with dateIn this example I have the count&nbsp; 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&nbsp;

lbendlin · Answer

Your sample data does not include dates.&nbsp; That means we cannot comment on the requirement&nbsp;
&nbsp;
I want to count how many parts with supplier more than 2 and supplier equal 1  and change with date

msayed26 · Answer

PartsPosting DateSuppliersW8TC1806100C05-01-2020AW43002256AC08-01-2020BW63X54HL08-01-2020BW4101839512-01-2020EW43011994S12-01-2020EW43016101S12-01-2020EW91104433S12-01-2020EW4300225614-01-2020BW43002256AC14-01-2020B

lbendlin · Answer

your sample data is insufficient to cover your scenarios.
&nbsp;

&nbsp;

Forum Discussion

distinct count

6 Replies

Related content

count distinct

Distinct Count

Distinct count

DAX Calculation for Distinct Count

Average - Distinct Count

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

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