Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have created 2 matrix from a table which shows stock on hand on a particular date. For date selection i have used 2 date slicers and have applied edit interaction so that 1st slicer is associated with 1st matrix and 2nd is associated with 2nd mateix. I wanna have a 3rd matrix which shows difference in stock between previous 2 matrix. How to do that?
Solved! Go to Solution.
Hi @Ash1807 ,
Please have a try.
You can create a third matrix that shows the difference in stock between the previous two matrices by using the "New Measure" option. You can create a measure that subtracts the value of the first matrix from the value of the second matrix. You can then add this measure to the third matrix.
Difference =
SUM ( Table[StockOnHand] )
- CALCULATE ( SUM ( Table[StockOnHand] ), ALLSELECTED () )
This formula calculates the difference between the sum of the "StockOnHand" column for the entire table and the sum of the "StockOnHand" column for the selected dates. You can then add this measure to the third matrix.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Ash1807 ,
Please have a try.
You can create a third matrix that shows the difference in stock between the previous two matrices by using the "New Measure" option. You can create a measure that subtracts the value of the first matrix from the value of the second matrix. You can then add this measure to the third matrix.
Difference =
SUM ( Table[StockOnHand] )
- CALCULATE ( SUM ( Table[StockOnHand] ), ALLSELECTED () )
This formula calculates the difference between the sum of the "StockOnHand" column for the entire table and the sum of the "StockOnHand" column for the selected dates. You can then add this measure to the third matrix.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
93 | |
86 | |
68 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |