Forum Discussion

rocky09's avatar
rocky09
Icon for Solution Sage rankSolution Sage
8 years ago
Solved

Running Totals by week

I have this below measure to get the cumulative count by weekly.  I am mapping this on Line and Clustered Chart.   On X axis I have week numbers and Column Values the Cumulative measure.  Up to here, it is working fine, However, when i insert Column Series, the measure shows the same value for every column (legend).

 

cumulative = CALCULATE([cntrows],FILTER(ALLSELECTED(tbl_Outreach),tbl_Outreach[WeekNumber]<=MAX(tbl_Outreach[WeekNumber]))) 

 without column series, the graph shows perfect.

 

If i introduce column series, the graph shows the same values for every column series.

 

 

any idea?

  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi rocky09,

     

    I think you need to add legend column as filter condition in your measure formula.
    Current formula haven't consider with legend, so if you enable legend column , each legend will has same calculation result.

     

    BTW, it will be help if you share some sample data.

     

    Regards,

    Xiaoxin Sheng

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi rocky09,

     

    I think you need to add legend column as filter condition in your measure formula.
    Current formula haven't consider with legend, so if you enable legend column , each legend will has same calculation result.

     

    BTW, it will be help if you share some sample data.

     

    Regards,

    Xiaoxin Sheng