Solved: Variance Column

Anonymous · ‎07-10-2024

I have a matrix set up like this

company 2023 2024 4+8 2024 5+7

Orders

Sales

OI

ROS

But I want a variance column measuring the difference from 5+7 to 4+8. I would want it to look like this

company 2023 2024 4+8 2024 5+7 Variance

Orders

Sales

OI

ROS

Does anyone know how I should approach this? I want the variance column to calculate each metric.

danextian · ‎07-10-2024

Hi @Anonymous ,

You will need a disconnected table and some advanced DAX for that. In the attached example, In-Progress is not a row in Brand Sold column but in Status but by using a disconnected table and measures, i've made it appear so.

Please see attached pbix for your reference.

Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

danextian · ‎07-10-2024

Hi @Anonymous ,

You will need a disconnected table and some advanced DAX for that. In the attached example, In-Progress is not a row in Brand Sold column but in Status but by using a disconnected table and measures, i've made it appear so.

Please see attached pbix for your reference.

Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.