SUMX in case of filter conditions

[Anonymous]

Hi All, 
This time I have dificulties to create a Measure of  SUM of SAP_JAN[In co. code currency] in following case (filtrations)
SAP_JAN[Account] = Admin[Account Number] = Category List[Category Level 1] = "Material cost (indirect & claims)"

Below you can find model 

and DAX formula i have tried to implemend 

Thank you in advance for you reply. 

[AlexisOlson · Accepted solution]

I think you're making it a bit more complicated than it needs to be, but the main problem is the SELECTEDVALUE inside the FILTER makes the equality true for every row in the table you're filtering. Try removing that SELECTEDVALUE or go with something simpler like this:

Material cost (indirect & claims ) =
IF (
    SELECTEDVALUE ( 'Category List'[Category Level 1] ) = "Material cost (indirect & claims)",
    SUM ( SAP_JAN[In co. code currency] ),
    " "
)