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?
Go to Solution.
Hi @opticshrewI 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 filterHope That HelpsVicente
View solution in original post
Your solution works a treat, thanks for the speedy reply.
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!