Running Totals by week

[rocky09]

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?

[v-shex-msft · Accepted solution]

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