Forum Discussion

George1973's avatar
George1973
Icon for Helper V rankHelper V
5 years ago

Variable as a single measure

Hi,   I have a complex measure with some variables:     Weighted Average = VAR OneLessMonthDailySales=DIVIDE( CALCULATE([Sold Prod Qnty],DATEADD(DateKey[Date],-1,MONTH)), CALCULATE([...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi George,

 

Can you try using 

IF.EAGER as in IF.EAGER your value will be computed for only one case when the tested condition is positive. In this way you can set a variable with measure value. This will improve the performace and will solve the issue as well.
  • George1973's avatar
    George1973
    Icon for Helper V rankHelper V
    5 years ago

    H,
    Can you provide a simple example of the "If.eager", because I have not heard about at so far 🙂

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      if.eager({condition that you can identify as a flag}, {Write your divide measure here}).