Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Variance Table For Two Matrices From the Same Data Set

Hi All,

I have two matrices that have been formed from a single dataset. Each matrix has a few filters and the fitlers for Matrix A do not interract with Matrix B and vice versa.

My problem is that I want to get a third matrix that displays the difference between the values in the first two matrcies, and in a dynamix fashion. Meaning, that the third matrix would update as I filter Matrix A or Matrix B (or both).

I was wondering if there is an easier way to do this than making duplicates tables of my original dataset?

Ideally there is a way to grab the values from a matrix dynamically and then use it in a simple subtraction to get the difference between Matrix A and Matrix B.

Thank you and any help is greatly appreciated!

Super User
Super User

@andfinn23 , I think you need two sets of dimensions, refer if these can help

Compare two Brands:


How to use two Date/Period slicers

Power BI Features || Datamarts: || Field Parameters :
Time Intelligence Decoded : || 50+Power Query List Functions : Learn Power Query List
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!

Helpful resources

September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors