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

Item have cat and Sub cat sa well 

 

 

Countorcale = CALCULATE (
DISTINCTCOUNT ('Data Source'[ItemAr]), DISTINCTCOUNT('Data Source'[CatAr]),DISTINCTCOUNT('Data Source'[SubAr]),'Data Source'[Orcale] = 1)

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

skorpion please provide the sub categorry below too with the expected result

 

Juice   1

Water 1

Juice  0

Water 1

Juice   1

Water 1

 

Output 

 

juice     2

Water   3

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

    solved thanks your help

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

    skorpion post the solution and make it the solution so others can learn from it