Forum Discussion

skorpion's avatar
skorpion
Icon for Helper I rankHelper 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
BalaVenuGopal's avatar
BalaVenuGopal
Icon for Resolver I rankResolver I
8 years ago

Hi skorpion ,

Could you please explain indetaled .

Assume you have the data like bellow

Category Value

A               100

A                200

B                50

B                60

Do you want to sum value for each category or do you  need max value from each category what is your requirement ??

Please explain in detailed.

If you need Sum of value for each category .

Create measure M1 = CALCUALTE(SUM(Value)) and then drag this measure and Category in your report will work .

 

Reply me if you need further assistance.

 

Regards,

Venu Gopal

  • skorpion's avatar
    skorpion
    Icon for Helper I rankHelper I
    8 years ago

    Looking for sum value for each category

    • vanessafvg's avatar
      vanessafvg
      Icon for Community Champion rankCommunity Champion
      8 years ago

      skorpion place the category on your visual, and then create the sum measure and put that on your visual and you will then seen what you asking for