Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hierarchy level total

Hello, I am facing issue with hierarchy level total.  It is showing incorrect total at top level for one field only.  Hierarchies- Rcode-Mcode-Hubname-dealer name Till 'Mcode' it is showing correc...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous m are you trying cumulative tota, then you should try like

 

Total units=

var lvalue= CALCULATE (
SUM(FactPJP[TotalNumberOfUnitsInMonth])
,filter(all(DimDate),DimDate[DateOfQuarter] = max(DimDate[date])))
RETURN lvalue

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks for the solution.