Forum Discussion
Ignore Filter in slicer
Yes that is what i expected, as I mentioned earlier, you need to use aggregated method like sum
TotalWithNewTable= IF(SELECTEDVALUE(NewTable[Column1])="USD", SUM(Table1[USDAmount]), SUM(Table1[EURAmount]) )
and add it as a measure.
Create a table that has no relationships to anything else in your model that has two rows and one column; column values shoudld have USD and EUR. Use these values in your slicer and in your measure condition. Since they are not related to anything, it won't filter data out that you want to keep.
I did that and it keeps the transactions but it doesn't update de amount value regarding the currency. I mean, it keeps with the TRUE value of the IF function in the measure, I did this:
TotalWithNewTable=IF(SELECTEDVALUE(NewTable[Column1])="USD",Table1[USDAmount],Table1[EURAmount])
It is not working
Are you getting error? Are you adding it as a measure or column? It need to be measure and you need to use aggregation method
parry2k I'm adding it as a column, as a measure it doesn't see my column value. How can I do that?
Yes that is what i expected, as I mentioned earlier, you need to use aggregated method like sum
TotalWithNewTable= IF(SELECTEDVALUE(NewTable[Column1])="USD", SUM(Table1[USDAmount]), SUM(Table1[EURAmount]) )
and add it as a measure.