DIstinct Count of Category Name Filtered by One of Multiple Demand Columns

[Anonymous]

Hi everyone,

I'm unable to get the correct distinct count of my product based on whether there is current demand, while I have two different demand columns which do not overlap in row entries. I provide simplified data in which I want it to be calculated like the following: 

As you can see, I want my Product column to be distinctly counted based on whether it is also populated by the Current Demand measure (this measure directly refencing a demand column in my data, since I want to create an explicit rather than implicit measure for Excel use). My thinking has been to create the following: Count=CALCULATE( DISTINCTCOUNT(ProductTable[Product],[Current Demand] <> BLANK()). However, it is not working. 

Please note that I don't have access to the most recent DAX functions such as DISTINCTCOUNTNOBLANK, so I hope there is still a way around this.

Any help will be much appreciated.

[Anonymous]

That works now, thanks!

[tamerj1 · Accepted solution]

Hi @Anonymous 

Pease try

COUNTX (

VALUES ( ProductTable[Product] ),

[Current Demand]

)