Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
In my matrix, I need to show (in a separate column to the right of the last column) the variance between "Contribution to XS" and "FL % of TTL INV". Contribution to Excess - FL % of TTL INV is not an option because "Contribution to XS" and "FL % of TTL INV" are the same fields as the first 2 columns you see below [FL INV] and [FL XS INV], but set as % of grand total because that is what I need shown.
I appreciate any help with this.
Solved! Go to Solution.
The clarification was great, thank you.
I replicated the portion of the data you shared into a table with an index column to get
I then wrote measures for FL XS RATE
Proud to be a Super User! | |
The clarification was great, thank you.
I replicated the portion of the data you shared into a table with an index column to get
I then wrote measures for FL XS RATE
Proud to be a Super User! | |
Hello,
I do not fully understand what you are looking for but if you can share the desired results for at least the first couple of rows I may be able to assist.
Cheers.
Proud to be a Super User! | |
Here's an example in excel (see below): basically =F2-G2
but it is not that simple in PowerBI desktop, unless I do not think it is. See explanation after screenshot.
The column above "Contribution to XS" is a field called 'Excess Inventory' [FL XS INV] and after renaming it for the visual, I set the field as % of grand total see image below: (same goes for the "FL % of TTL INV" column in the image above).
I'm not too sure how to create a measure to give me the desired result (shown in column H of first image).
Please let me know if I am still unclear or need to provide additional information.
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
185 | |
92 | |
67 | |
62 | |
52 |