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