Forum Discussion

lacq's avatar
lacq
Regular Visitor
8 years ago
Solved

DAX: Rollup value within a group

Hi Community,   I've one question, maybe a silly one, but I already wasted some time trying to solve the following requirement...   I've the following very simple star schema model in my PBI file...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi lacq

     

    First add a calculated column in your FactValues

     

    Use this Column in the Visual

     

    CountryName = related(DimCountry[CountryName])

     Now you can use this MEASURE to get the Cumulative

     

    Cumulative =
CALCULATE (
    SUM ( FactValues[Value] ),
    FILTER (
        ALLEXCEPT ( FactValues, FactValues[CountryName] ),
        FactValues[Date] <= SELECTEDVALUE ( FactValues[Date] )
    )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi lacq

 

First add a calculated column in your FactValues

 

Use this Column in the Visual

 

CountryName = related(DimCountry[CountryName])

 Now you can use this MEASURE to get the Cumulative

 

Cumulative =
CALCULATE (
    SUM ( FactValues[Value] ),
    FILTER (
        ALLEXCEPT ( FactValues, FactValues[CountryName] ),
        FactValues[Date] <= SELECTEDVALUE ( FactValues[Date] )
    )
)