Forum Discussion
Issue with different data between Matrix and Bar chart
Hi,
I have an issue where I have a Barchart (image 1) with a set of Sum measures where the X-axis is Year-Month and on another page I show the same measures in a Matrix visual (image2), but the Sum isn't the same as in de Barchart.
I have tried deleting the cache in the report and the stored cookie data in browser of the users. Sometimes this resolves the issue, but it keeps coming back.
Anyone experience the same issue, or have some pointers on how to resolve this?
Image1
Image2
4 Replies
Jdiepen Can you check the page level / visual level filters between the two visuals ?
Hey Jai,
See below. The filter influence is the same, that's why I am surprised with the different result.
Matrix filters
Barchart filters
Jdiepen try replacing SUM with SUMX function in your measures like below
Discount = SUMX('Table','Table'[Discounts])Did I answer your question? If yes, please mark my post as a solution.
Thanks,
Jai
Hello, Jai-Rathinavel ,thanks for your concern about this issue.
Your answer is excellent!
Hi,Jdiepen .I am glad to help you.Has your problem been solved?
If you have found suitable solutions, please share them as it will help more users with similar problems.
Or you can mark the valid suggestions provided by other users as solutions.
Thank you very much for your understanding and support of Power BI.I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
