Make a value as negative depending on a parameter from another table

[Tybaal]

Hi everyone, 

I'd like to value from my fact table negative if a field from a dimension table has a certain value.

For exemple : 

If ('Dimension Type'[Type] = "A", SUM('Fact sales'[Amount] * -1, IF('Dimension Type'[Type] = "B", SUM('Fact sales'[Amount]))

Both tables are linked of course.

Can you tell me how I can do that?

Thank you in advance.

[amitchandak · Accepted solution]

@Tybaal , something like this

if (max('Dimension Type'[Type]) = "A", SUM('Fact sales'[Amount]) * -1, IF('Dimension Type'[Type] = "B", SUM('Fact sales'[Amount])))

or

sumx(values('Dimension Type'[Type]) ,if ('Dimension Type'[Type] = "A", SUM('Fact sales'[Amount]) * -1, IF('Dimension Type'[Type] = "B", SUM('Fact sales'[Amount]))))

[Tybaal]

Thank you @amitchandak , it works with your first proposition :

if (max('Dimension Type'[Type]) = "A", SUM('Fact sales'[Amount]) * -1, IF(max('Dimension Type'[Type] = "B", SUM('Fact sales'[Amount])))

But can you explain why it didn't work without the 'max'? (sorry i'm a beginner in DAX)