Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |