Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
Hi @Anonymous
Pease try
COUNTX (
VALUES ( ProductTable[Product] ),
[Current Demand]
)
That works now, thanks!
Hi @Anonymous
Pease try
COUNTX (
VALUES ( ProductTable[Product] ),
[Current Demand]
)