Forum Discussion
Helper IIMake a value as negative depending on a parameter from another table
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.
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]))))
2 Replies
- amitchandak
Super User
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]))))
TybaalThank 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)