Forum Discussion

easyleesie's avatar
easyleesie
Icon for Helper I rankHelper I
6 years ago
Solved

Cumulative total for two dimensions. DAX for Measure

Hi All   I followed a response to this and replied, but I'm not sure its getting noticed.   This is my DAX: CumDAC = CALCULATE( sum(FactTable[DAC]), FILTER( ALLSELECTED(FactTable), FactTabl...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    easyleesie 

     

    I think too many closed bracket in your formula.

    CumDAC =
CALCULATE(
sum(FactTable[DAC]),
FILTER(
ALLSELECTED(FactTable),
FactTable[Date]
<=max(
FactTable[Date] )
&& FactTable[Policy]=SELECTEDVALUE(FactTable[Policy])
)
)

    Could you please try the formula about and make sure the brackets should show up in pairs in the formula.

     

     

easyleesie's avatar
easyleesie
Icon for Helper I rankHelper I
6 years ago

Hi Ryan

 

That gives:

 

The syntax for ')' is incorrect. (DAX(CALCULATE( sum( FactTable[DAC] ), FILTER ( ALLSELECTED( FactTable ), FactTable[Date] <=max ( FactTable[Date]) && FactTable[Policy] = SELECTEDVALUE( FactTable[Policy] ) ) ) ))).

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
6 years ago

easyleesie 

 

I think too many closed bracket in your formula.

CumDAC =
CALCULATE(
sum(FactTable[DAC]),
FILTER(
ALLSELECTED(FactTable),
FactTable[Date]
<=max(
FactTable[Date] )
&& FactTable[Policy]=SELECTEDVALUE(FactTable[Policy])
)
)

Could you please try the formula about and make sure the brackets should show up in pairs in the formula.

 

 

  • easyleesie's avatar
    easyleesie
    Icon for Helper I rankHelper I
    6 years ago

    Hi Ryan

     

    So grateful! Thanks man.

     

    Easy.