Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
ALL() is a filter function, it's not return any number to divide
try
Divide(
[CustomerShareOfSales],
CALCULATE(SUM(SalesInvoices[TotalSum]), ALL(SalesInvoices) )
)
ALL() is a filter function, it's not return any number to divide
try
Divide(
[CustomerShareOfSales],
CALCULATE(SUM(SalesInvoices[TotalSum]), ALL(SalesInvoices) )
)
Thank you this works! Do i understand the CALCULATE in this correctly: It creates a new filter context in which the SUM is evaluated in and is therefore mandatory?
well,CALCULATE() in this case allows you to evaluate ALL() context as a filter
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |