Problem creating measures in a measure-table

[Carlsberg987]

Hi,

I have a separate Measure table set up and im trying to create measures there to use in my visuals. For some reason I fail to create a percentage measure, that gives the customer's share of total sales. What am I doing wrong here? Apparently the result is not a single figure.

Total sales per customer (works):

CustomerShareOfSales = SUMX(

'SalesInvoices',

'SalesInvoices'[TotalSum]

)

Total percentage of sales per customer (does not work):

CustomerShareOfSales-% =

Divide([CustomerShareOfSales],ALL('SalesInvoices'[TotalSum]))

[az38 · Accepted solution]

@Carlsberg987 

ALL() is a filter function, it's not return any number to divide

try

Divide(
[CustomerShareOfSales],

CALCULATE(SUM(SalesInvoices[TotalSum]), ALL(SalesInvoices) )
)

[Carlsberg987]

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?

[az38]

@Carlsberg987 

well,CALCULATE() in this case allows you to evaluate ALL() context as a filter