Measures within tables

[opticshrew]

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 many customers have ordered a specific product so I have created a measure works out the following:

Total Customers with Product / Total Customers (This is shown as a percentage)

Total customers seems to get filtered by each row of the table and therefore it works this out instead

Total Customers with Product / Total Customers (Filtered by product row)

Is there anyway I can stop Total Customers from being filtered and rather calculate as if all Customers were available even those who did not purchase the product?

Thanks,

J

[vcastello · Accepted solution]

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]

Hi @vcastello

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

Thanks,

J