Forum Discussion
Help with Distinct Count
Hi, I am trying to write some DAX to get the distict count of SKUs that have a certain threshold of CM%. I have a measure calculating CM % and a measure calculating the distinctcount of SKUs in ...
Hi Anonymous
Modify your formula by adding the "filter" function.
Something like :
CountofSKUsnegCM% = CALCULATE(DISTINCTCOUNT(Data[SKU]), filter (your table,[CM%]<0))In case it still doesn't work out,
please attach your table and the desired result.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly