Forum Discussion
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?
- Anonymous8 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
- AnonymousNot 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