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.

pcavacas's avatar
pcavacas
Helper I
6 years ago

I realize that SelectedValue takes a single value, but it is in a Sumx, the below DAX is closer to the real formula that I'm using.  You can see that the SelectedValue is still valid because it is part of the SumX iterator.

 

SUMX (
'VF APF Rate',
'VF APF Rate'[Rate]
* CALCULATE (
[Latest Estimate Revenue],
FILTER (
ALL ( 'VF Demand Forecast' ),
'VF Demand Forecast'[PlanAccountID] = SELECTEDVALUE ( 'VF APF Rate'[PlanAccountID] )
&& 'VF Demand Forecast'[PrdId] = SELECTEDVALUE ( 'VF APF Rate'[Product Code] )
&& 'VF Demand Forecast'[Date] >= SELECTEDVALUE( 'VF APF Rate'[MinDate] )
&& 'VF Demand Forecast'[Date] <= SELECTEDVALUE( 'VF APF Rate'[MaxDate] )
)
)
)
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
        )
         
        )
        )