Forum Discussion

skorpion's avatar
skorpion
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...
Need Help
Show and Tell
Tips and Tricks
vanessafvg's avatar
vanessafvg
Community Champion
8 years ago

skorpion  why are you combining 2 different measures?

 

this should give you the total sum

SumofSales= CALCULATE(SUM('Data Source'[Sales) )

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

 

what result are you expecting?, if you create them separately then place them on your visual you can still see them together.

 

please give an example of what you hope to achieve

  • skorpion's avatar
    skorpion
    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 

    • vanessafvg's avatar
      vanessafvg
      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's avatar
        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]))