Forum Discussion

UrAvgWally's avatar
UrAvgWally
Icon for Helper I rankHelper I
4 years ago
Solved

Cumulative Total , no dates

Hi all,   I am trying to turn this line chart into a cumulative chart :      The data Source looks like this , the X axis is the period Column   The Y Axis is based on these values...
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    UrAvgWally Yeah, there is a stray ) in there:

    Measure = 
VAR PNo = MAX(PeriodicTable[PeriodNo])
VAR Periods = 
  SELECTCOLUMNS(
    FILTER(
      ALL(PeriodicTable), 
      [PeriodNo] <= PNo
    ),
    "__PeriodMFMA",
    PeriodicTable[PeriodMFMA]
  )
VAR Table = FILTER(UnpivotCP,[PeriodMFMA] IN Periods)
RETURN
SUMX( Table,[Value])
UrAvgWally's avatar
UrAvgWally
Icon for Helper I rankHelper I
4 years ago

Greg_Deckler Awesome! The code fixed the issue and is now showing cumulative.

 

Although my slicer for different functions not working for that.I ideally want to be able to Slice by function , is there a way to enable that? As per above I use RSKCL[Function] as a slicer, which has a relation to the Funder column.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

UrAvgWally You will want to use ALLEXCEPT instead of ALL in that case. Basically ignore all of the context except for the context you specify.

  • UrAvgWally's avatar
    UrAvgWally
    Icon for Helper I rankHelper I
    4 years ago

    Alright, thanks . Thank you for being patient with me. Will start reading the book on Dax over the weekend to learn, it is arriving tommorow. 

     

    The Allexcept is having syntax error :

     

     

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    4 years ago

    UrAvgWally ALLEXCEPT takes additional parameters. So something like:

    VAR Table1 = FILTER(ALLEXCEPT(UnpivotCP, 'UnpivotCP'[Function]),[PeriodMFMA] IN Periods)

    So that code would ignore all context other than context created by a Function column in your UnpivotCP table for example.