Forum Discussion
Count and sum unique Values
Im trying to get the sum of Sales with uniuqe Catatery im using thus DAX Formula please anyone can help me in this Countoracle = CALCULATE(SUM('Data Source'[Sales) ,DISTINCTCOUNT ('Data Source'[I...
skorpion ill be honest you still not explaining very well, whats helpful is to show me some of your data and then what result you expect? trying to help wtih all the information helps
if i understand what you saying you only want unique products? unique products is 1 or 0? data will really help here
CALCULATE (
DISTINCTCOUNT ('Data Source'[ItemAr]), columnsale = 0)
that will give you the total count of all products that that have 0 columnsale
Its very hard to explain
For exampple
Juice 1
Water 1
Juice 0
Water 1
Juice 1
Water 1
Output
juice 2
Water 3