Create a DISTINCTCOUNT and show that total on every row

[dkernen2]

I need a little help.  I have a DAX Measure that counts the number of unique vendors: 

DISTINCTCOUNT(TABLE[Vendor ID])

What I need to do is to put that distinct count on every row of the matrix (that meets my year filter).

Simple example where I have three years that meet my years slicer but I have two distinct vendors and I need that 2 on every row.

Category	Year	Vendor	DISTINCT (have)	DISTINCT TOT (need)
A	2018	ABC	1	2
A	2019	DEF	1	2
A	2020	DEF	1	2
Total			2	2

https://kauffman.box.com/s/2n6ccf18xkfzrmxopltujibbasxeqbrr

Thank you in advance!

[dkernen2]

Thank you!  That gave me the total for ALL vendors in my table, not vendors related to each category.  I think I need to do something with ALLSELECTED for the years given for the current category.

[nsexton12]

Ah, okay! I misunderstood your requirement. You could use ALLEXCEPT and then put the column name in that you want it to still filter by. So, 

CALCULATE(DISTINCTCOUNT(TABLE[Vendor ID]),ALLEXCEPT(TABLE,TABLE[Vendor ID]))

[dkernen2 · Accepted solution]

This may be overkill, but it works:

VAR _curID = MAX(TABLE[Category ID])

VAR _yrmin = CALCULATE(MIN('Review Years'[Review Year]),ALLSELECTED('Review Years'[Review Year]))

VAR _yrmax = CALCULATE(MAX('Review Years'[Review Year]),ALLSELECTED('Review Years'[Review Year]))

VAR _uniq = CALCULATE([Vendor Count],

   FILTER(ALL(TABLE),

     TABLE[Category ID] = _curID &&

     TABLE[Review Year] >=_yrmin &&

     TABLE[Review Year] <=_yrmax))

RETURN _uniq

[nsexton12]

You can use the calculate function in combination with the ALL function. So, 

CALCULATE(DISTINCTCOUNT(TABLE[Vendor ID]),ALL(TABLE))

Please mark as a solution if this works for you!