how to sum values on 3 different category per date

[animale0913]

Good day! Please help me with my concern, I have data below which i want to get the sum on their 3 different category per date

LANE	SERVICE	CLASS	TRANSACTIONS	PRODUCTIONS	PROD_DATE
AIR	FORWARDING	IMPORT	200	25000	8/31/2024
AIR	FORWARDING	IMPORT	125	10000	8/31/2024
AIR	FORWARDING	IMPORT	50	5000	9/31/2024
AIR	FORWARDING	IMPORT	75	20000	9/31/2024
AIR	BROKERAGE	EXPORT	200	19000	8/31/2024
AIR	BROKERAGE	EXPORT	175	10000	8/31/2024
AIR	BROKERAGE	EXPORT	60	5000	9/31/2024
AIR	BROKERAGE	EXPORT	75	20000	9/31/2024
SEA	FORWARDING	IMPORT	130	25000	8/31/2024
SEA	FORWARDING	IMPORT	95	10000	8/31/2024
SEA	FORWARDING	IMPORT	50	12000	9/31/2024
SEA	FORWARDING	IMPORT	25	16000	9/31/2024
SEA	BROKERAGE	EXPORT	200	25000	8/31/2024
SEA	BROKERAGE	EXPORT	90	10000	8/31/2024
SEA	BROKERAGE	EXPORT	35	4000	9/31/2024
SEA	BROKERAGE	EXPORT	75	17000	9/31/2024

Desired Output

LANE	SERVICE	CLASS	TOTAL TRANSACTION	TOTAL PRODUCTIONS	PROD DATE
AIR	FORWARDING	IMPORT	325	35000	8/31/2024
AIR	FORWARDING	IMPORT	125	25000	9/31/2024
AIR	BROKERAGE	EXPORT	375	29000	8/31/2024
AIR	BROKERAGE	EXPORT	135	25000	9/31/2024
SEA	FORWARDING	IMPORT	225	35000	8/31/2024
SEA	FORWARDING	IMPORT	75	28000	9/31/2024
SEA	BROKERAGE	EXPORT	290	35000	8/31/2024
SEA	BROKERAGE	EXPORT	110	21000	9/31/2024

Thanks in advance!

[tharunkumarRTK · Accepted solution]

@animale0913 

For your desired result

You do not need to do anything for your desired result. Leverage implicit measures feature.

Just add all the required columns into the Table visual and make sure you added 'Sum' aggregation on numeric columns TRANSACTIONS and PRODUCTIONS and Thats it! 

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[animale0913]

Thank you for your reply, another question is what if i want it to be in matrix format like below;

	EXPORT	IMPORT
	FORWARDING	BROKERAGE	FORWARDING	BROKERAGE
PROD_DATE	TRANSACTIONS	PRODUCTIONS	TRANSACTIONS	PRODUCTIONS	TRANSACTIONS	PRODUCTIONS	TRANSACTIONS	PRODUCTIONS
8/31/2024
9/31/2024