Search code examples
powerbidaxvisualizationpowerbi-desktopmeasure

Trouble in SVG Sales Sum and Average Display

_Hi, I have worked on an SVG example in which I chose to display the sum of sales and the total average sales for both the current and previous year.
However, I am struggling with the current sales year average in the table, which is incorrect, even though it appears correct in a card. I can't figure out why?
Furthermore, the average bar for the current year appears to be okay, but not the one for the previous year... Can someone help me ? Thanks in advance for your time. Here is the link of my pbix file enter image description here

Solution

  • That's my code ;).

    You have a filter on the table which is why you're seeing a different figure. Remove the filter and you'll see the correct figure.

    enter image description here

    enter image description here