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.
