DAX - SUM partition by Columns and filters by Date range slicer

[databot_kd]

Hi community, 

i am trying to create a measure that sums the total amount over company, supplier and transaction number but is still filtered based on the date range slicer selection. 

I was able to create a measure that sum the amount over the company, supplier and trx reference but it does not filter based on the slicers selected dates. 

Current DAX = CALCULATE( SUM ( Amout), ALLEXCEPT( COMPANY, SUPPLIER, TRX_CODE)) 

Below screemshot explains the data output i am trying to achieve

Below is sample data. 

Sample Data
Company	Supplier	Trx Num	Trans Date	Amount
PRQ Ltd	Rusteeze	RQ-100012	27/12/2023 0:00	-10000
PRQ Ltd	Rusteeze	RQ-100012	5/01/2024 0:00	11000
PRQ Ltd	Rusteeze	RQ-100012	5/01/2024 0:00	-1000
ANZ	Stainless Steel	P1MC -011	27/12/2023 0:00	-455
ANZ	Stainless Steel	P1MC -011	5/01/2024 0:00	455
Trible	AASP	AS789-088	9/01/2024 0:00	100
Trible	AASP	OCMM138	10/01/2024 0:00	250

[amitchandak · Accepted solution]

@databot_kd , Try a measure like

CALCULATE( SUM (Table[ Amout] ), filter( allselected(Table), Table[COMPANY] = max(Table[COMPANY]) && Table[SUPPLIER] = max(Table[SUPPLIER]) && && Table[TRX_CODE] = max(Table[TRX_CODE]) ))

Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s

[databot_kd]

Thanks @amitchandak  for the solution.