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
dilumd's avatar
dilumd
Icon for Impactful Individual rankImpactful Individual
9 years ago

Hi,

 

Below function will consider all columns in your data table except Batch # column,

 

Count of Raws = CALCULATE(COUNTROWS(CountRaws),ALLEXCEPT(CountRaws,CountRaws[Batch#]))

 

However, if you use below formula with ALL function it will ignore all filters inside the table.

 

Count of Raws = CALCULATE(COUNTROWS(CountRaws),ALL(CountRaws[Batch#]))

 

 

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.