Forum Discussion
Solved
Ignore Filter in slicer
Hi all I see many topics about this but i couldn't find the answer that i was looking. I have a slicer that has these values: USD and EUR. This are from a table where I have transactions (some ...
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.
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.