Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Problem creating measures in a measure-table

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 t...
Need Help
  • az38's avatar
    az38
    6 years ago

    Anonymous 

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

    try

     

    Divide(
[CustomerShareOfSales],

CALCULATE(SUM(SalesInvoices[TotalSum]), ALL(SalesInvoices) )
)
az38's avatar
az38
Community Champion
6 years ago

Anonymous 

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

try

 

Divide(
[CustomerShareOfSales],

CALCULATE(SUM(SalesInvoices[TotalSum]), ALL(SalesInvoices) )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      az38
      Community Champion
      6 years ago

      Anonymous 

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