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
BalaVenuGopal's avatar
BalaVenuGopal
Resolver 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
Helper I
8 years ago

Looking for sum value for each category

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