Two slicers in one table with filtered data

[HB__BH]

Hi all,

I'm having trouble creating one matrix visual with all the data come from one table behind.

Now, I'm able to visualize with Format--> Edit Interactions and applying two slicers in two matrices. Since we need to know Increase Qty and Decrease Qty the data table is filtered and aggregated by SUMX and FILTER functions in a measure like:

IncreaseQty = SUMX(FILTER('Data Table', 'Data Table'[Entry Type]="Increase"),'Data Table'[QTY])

When I add the sum of Starting Qty to the Values of the Matrix including IncreaseQty I got numbers that I don't look for 😕

However in the final visualization the Start of Period Qty, Increase Qty, Decrease Qty, End of Period Qty are supposed to be in one visual.

Could you please send your thoughts how to make it only in one table/matrix visual.

______________________________________

I have data similar to this:

DATE	INVENTORY GROUP	ITEM No.	DESCRIPTION	ENTRY TYPE	QTY
2022-12-31	GOODS	Barley-22	Barley	Increase	4
2023-01-06	GOODS	Barley-22	Barley	Increase	8
2023-01-07	GOODS	Barley-22	Barley	Decrease	15
2022-12-31	GOODS	Corn-21	Corn	Increase	15
2022-12-31	GOODS	Corn-22	Corn	Increase	32
2023-01-01	GOODS	Corn-22	Corn	Decrease	5
2023-01-08	GOODS	Corn-21	Corn	Decrease	8
2023-01-10	GOODS	Corn-22	Corn	Increase	10
2022-12-31	GOODS	Soy-22	Soy	Increase	4

I want sg like this:

INVENTORY GROUP		2022-12-31			2023-01-13
Item No.	Description	Start of Period Qty	Increase Qty	Decrease Qty	End of Period Qty

[JohnShepherdAPD]

Hi im not 100% clear on what you are trying to do but this option might help you?

[HB__BH]

Thank you! I haven't used that option so far. However we didn't get closer now.

To make clear I'm trying to use two slicers on one dataset in a table/matrix visual while some colums in the visual are filtered.