Forum Discussion

Helper I

8 years ago

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...

Tips and Tricks

Helper I

8 years ago

yea but when i sum value it will sum all Cataery which repeat and have twice so i need Uniqe sum

Community Champion

8 years ago

skorpion please provide an example of what you expecting as i am unclear what you trying to do

are you wanting to count the total products, total categories, total sales value

provide an example of what it should look like

skorpion
Helper I
8 years ago
this is the Distinct Formula for Item

CountDataset = CALCULATE (
DISTINCTCOUNT ('Data Source'[ItemAr]))

which working Fine

Now there is one more Column where we mention 1 = Yes and 0 = No

now in Excel column Item have muti entries and Column Sale have 1 and 0

so i need in Power BI sum All Unique Sale Item with this CountDataset = CALCULATE (
DISTINCTCOUNT ('Data Source'[ItemAr]))
- vanessafvg
  Community Champion
  8 years ago
  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
  - skorpion
    Helper I
    8 years ago
    Its very hard to explain
    
    For exampple
    
    Juice 1
    Water 1
    Juice 0
    Water 1
    Juice 1
    Water 1
    
    Output
    
    juice 2
    Water 3