Forum Discussion

pcavacas's avatar
pcavacas
Helper I
6 years ago
Solved

Problem with Row context

I have a report that has a bunch of columns on it and have a weird behavior that I cannot figure out what is going on.  One of the formulas, the APF colum, is blank for all rows that are not at the l...
  • lbendlin's avatar
    lbendlin
    6 years ago

    Good to hear. What I learned from this is that only the first expression of the Calculate() is impacted by the context transition.  That was not clear to me before.

lbendlin's avatar
lbendlin
Super User
6 years ago

Did you know that  you can pack variables inside the sumx ?

 

sumx(
var a=selectedvalue(b)

return caclulate()

)

 

etc.

pcavacas's avatar
pcavacas
Helper I
6 years ago

No I did not know that, but even when I change it to using variable I get the same results.

    • pcavacas's avatar
      pcavacas
      Helper I
      6 years ago

      This is the measure that I have

      SUMX (
      'VF APF Rate',
      var planAccountId = SELECTEDVALUE ( 'VF APF Rate'[PlanAccountID] )
      var productCode = SELECTEDVALUE ( 'VF APF Rate'[Product Code] )
      var minDate = SELECTEDVALUE( 'VF APF Rate'[MinDate] )
      var maxDate = SELECTEDVALUE( 'VF APF Rate'[MaxDate] )

      Return
      'VF APF Rate'[Rate]
      * CALCULATE (
      [Latest Estimate Revenue],
       
      FILTER (
      ALL ( 'VF Demand Forecast' ),
      'VF Demand Forecast'[PlanAccountID] = planAccountId
      && 'VF Demand Forecast'[PrdId] = productCode
      && 'VF Demand Forecast'[Date] >= minDate
      && 'VF Demand Forecast'[Date] <= maxDate
      )
       
      )
      )