I have this report that you see here with an issue on my cumulative graph. When you hover over the bar in the cumulative revenue graph, you'll see that the cumulative revenue tooltip doesn't match the total for 2021 revenue in the summary table. Here is all I know so far:When i review this dax I used to create that cumulative measure, removing the section in red related to the "product mix of orders" filter on the report seems to correct the calculation (as long as i don't filter on that item).CumulativeRevenue = CALCULATE(SUM(TreeNursuryLineItems[Amount]),FILTER(ALL(TreeNursuryLineItems),TreeNursuryLineItems[Order Date] <= MAX(TreeNursuryLineItems[Order Date])),VALUES(TreeNursuryLineItems[FiscalYear]),VALUES(TreeNursuryLineItems[Order Status]),VALUES(TreeNursuryLineItems[Project_Type]),VALUES(TreeNursuryLineItems[ProductGroup])) Additionally, when i convert the bar graph to a table and highlight the 2021 portion of the summary table, the numbers are correct and adjust with any of the filters (slight difference from rounding change). What am i missing so that the numbers in the bar graph are not correct? Here is a link to the pbxi file to view.https://arbordayfarm-my.sharepoint.com/:u:/g/personal/mbaldwin_arborday_org/EXbseJigroJEjZR3jeNfBkAB0cSHF5nUuI1WhMEfq1h5CA?e=BLDfdK

Hi, Share the link from where i can download your PBI file.

Thanks for replying. I think I was able to share the pbx file...

Hi, You may download the PBI file from here. Hope this helps.

Thanks for taking a look at this. One thing i noticed was that on the file you shared, the current month's data is replicated across future months for the current Fiscal year (20-21). I couldn't figure out how to cut that off October on your code like you see in my original. Also, I've tried using DATESYTD function before to build this graph and didn't get the same result. What was the key here? was it just having that Dates table that you built?

Hi, You are welcome. You may modify my cumulative revenue measure with an IF statement. If the revenue is 0, then blank else my cumultive revenue measure. If you are unable to do it, post back.

Mattbidev101

Helper I

5 years ago

Filter on Cumulative YOY graph not working

I have this report that you see here with an issue on my cumulative graph. When you hover over the bar in the cumulative revenue graph, you'll see that the cumulative revenue tooltip doesn't match the total for 2021 revenue in the summary table.

Here is all I know so far:

When i review this dax I used to create that cumulative measure, removing the section in red related to the "product mix of orders" filter on the report seems to correct the calculation (as long as i don't filter on that item).

CumulativeRevenue = CALCULATE(SUM(TreeNursuryLineItems[Amount]),FILTER(ALL(TreeNursuryLineItems),TreeNursuryLineItems[Order Date] <= MAX(TreeNursuryLineItems[Order Date])),VALUES(TreeNursuryLineItems[FiscalYear]),VALUES(TreeNursuryLineItems[Order Status]),VALUES(TreeNursuryLineItems[Project_Type]),VALUES(TreeNursuryLineItems[ProductGroup]))

Additionally, when i convert the bar graph to a table and highlight the 2021 portion of the summary table, the numbers are correct and adjust with any of the filters (slight difference from rounding change).

What am i missing so that the numbers in the bar graph are not correct?

Here is a link to the pbxi file to view.

https://arbordayfarm-my.sharepoint.com/:u:/g/personal/mbaldwin_arborday_org/EXbseJigroJEjZR3jeNfBkAB0cSHF5nUuI1WhMEfq1h5CA?e=BLDfdK

Need Help

Forum Discussion

Filter on Cumulative YOY graph not working

16 Replies

Related content

Cumulative Total

filter? Cumulative subtraction doesn't work

Filters not working properly

Creating Cumulative Graphs

Cumulative total more than current value using current filters