Forum Discussion
Divide one Matrix Column By Another
This is my report page I have two matrices on the left one calculating sales top left and one the amount of returns top right, I then have a matrix combining both and then adding in a measure calculating the returns rate - however my matrix are filtered differently so when combined one filter affects the other meaning I am not seeing all of the sales as there is no returns (not displaying zero values)
Anyway round this?
2 Replies
ChadM93 , You have to create measures, that might require an independent table
example
Compare Categorical Data Using Slicers - Compare two Brands: https://youtu.be/exN4nTewgbc
How to use/compare two Date/Period slicers: https://youtu.be/WSeZr_-MiTg
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.Thanks for the reply, I will give these videos a watch first to get a better understanding and give it a go
