Forum Discussion

opticshrew's avatar
opticshrew
Resolver II
8 years ago
Solved

Measures within tables

Hi all,   I'm getting an issue around using measures within a table, bear with me whilst I try to explain.   Table 1 : Product Codes Table 2 : Customers Table 3 : Sales   I want to know how m...
Need Help
  • vcastello's avatar
    vcastello
    8 years ago

    Hi opticshrew

    I think you may have to use the ALL() function.

    It should be s'thing like ...

     

    Absoulte Total Customers = CALCULATE(DISTINCTCOUNT(TableCustomers[CustomerID),ALL(TableCustomers))

     

    Using ALL() you get rid of the filter

    Hope That Helps

    Vicente

vcastello's avatar
vcastello
Resolver III
8 years ago

Hi opticshrew

I think you may have to use the ALL() function.

It should be s'thing like ...

 

Absoulte Total Customers = CALCULATE(DISTINCTCOUNT(TableCustomers[CustomerID),ALL(TableCustomers))

 

Using ALL() you get rid of the filter

Hope That Helps

Vicente

  • opticshrew's avatar
    opticshrew
    Resolver II
    8 years ago

    Hi vcastello

     

    Your solution works a treat, thanks for the speedy reply.

     

    Thanks,

    J