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
Anonymous's avatar
Anonymous
Not applicable
9 years ago

aaditya2000,

Firstly, select the three columns in TABLE-1, then select “Remove Duplicates”.


Secondly, create relationship between TABLE-1 and TABLE-2 using ID field.

Thirdly, create the following measures in TABLE-1 and create table visual.

Count of stores = DISTINCTCOUNT('TABLE-1'[storename])
Count of batch = CALCULATE(COUNT('TABLE-2'[Batch1#]))
Measure 2 = [Count of stores]*[Count of batch]


Regards,

  • aaditya2000's avatar
    aaditya2000
    Helper II
    9 years ago

    Hello:

     

    Thank you for your reply. The solution you provided is doable, but i amnot seeing filtering cutomer in the measure calculations.

     

    I see customer names in table but not in measure calculations.

     

    Is it i am missing something over here?

     

    Please help.

     

    Thanking in advance.

     

    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      aaditya2000,

      When you add customer field in table, the measure is calculated by customer. You can remove customer field from the above table visual and you will see the measure result is different.

      Regards,
      Lydia