Dax to sum a value column based on two filters

[sivarajan21]

Hi,

I have the below table :

I need to sum the value column with respect to TargetType =0 and their corresponding Value Type.

My dax takes is as below:

Target Unit =
CALCULATE (
SUMX ( Target, Target[Value] ),
FILTER ( Target, Target[TargetType] = 0 )
)

This dax takes into consideration TargetType =0 but not Value Type. I have multiple Value Type such as Value_03,Value_02,Value_01 upto Value_12.

Could you please help me?

PFA raw excel file test.xlsx

Please let me know if you need further info!

Thanks in advance!

@Ahmedx @Greg_Deckler @grantsamborn @amitchandak @Sergii24 

[sivarajan21]

Hi Sir,

I have accepted it as a solution!

Thank you!

[Ahmedx · Accepted solution]

plse thr this

CALCULATE (
SUMX ( Target, Target[Value] ),
Target, Target[TargetType] = 0 && Target[Value Type] in {"Value_01","Value_02","Value_3","Value_12" } )

[sivarajan21]

Hi @Ahmedx ,

Amazing solution! thanks,

I will have a look and get back sir

Thanks