Forum Discussion

aaditya2000's avatar
aaditya2000
Helper 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
Impactful 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
    Helper 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
      Impactful Individual
      9 years ago

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