Forum Discussion

andywil456's avatar
andywil456
Advocate II
10 years ago

calculate formula

I trying to pull through the total sales from another table but i want it to show the break down as per each payment category which is cross referenced by index numbers. The formula i'm using is Colu...
Habib's avatar
Habib
Continued Contributor
10 years ago

Apply filter on your referenced table within CALCULATE funtion it might work as I am not sure about exact error.

  • andywil456's avatar
    andywil456
    Advocate II
    10 years ago

    Hi Habib,

    Below is a screenshot of the table i have created and the error message.

    What i'm after is a breakdown of the total supplier spend by payment category. 

     

    • Habib's avatar
      Habib
      Continued Contributor
      10 years ago

      andywil456CALCULATE function expect filter as second parameter but in your scenario your are providing column value. Please add some filter option like ALL or ALLSELECTED.

      • andywil456's avatar
        andywil456
        Advocate II
        10 years ago

        Thank you Habib, now i'm getting another issue. Using either filter ALL or ALLSELECTED i'm getting a total value of £26m but the supplier amounts should only total £8.5m.

        I have applied the same formula to my customer amounts and they match. 

        The step up between each table is the same apart when i select "make this relationship active" i get this error message 

        .