Forum Discussion

aaditya2000's avatar
aaditya2000
Icon for Helper II rankHelper II
9 years ago

CALCULATE help

Hello:   I want the COUNT of Batch# for all storename for each customer. below is the screenshot.   I am looking for something like this. XYZ-->ALL storename-->Count of all Batch# MEASURE = 4 (...
Need Help
aaditya2000's avatar
aaditya2000
Icon for Helper II rankHelper II
9 years ago

Thank you for your reply. want to know how i can do that where based on customer, i want to total count = total stores X count of batch.

 

for e.g = 4 stores X count of batch (4)

           = 16.

 

thanks

dilumd's avatar
dilumd
Icon for Impactful Individual rankImpactful Individual
9 years ago

you can use SUM or SUMX functions based on your ultimate goal.