Forum Discussion

Juramirez's avatar
Juramirez
Resolver I
8 years ago
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 ...
Need Help
Show and Tell
Tips and Tricks
  • parry2k's avatar
    parry2k
    8 years ago

    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. 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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.

  • Juramirez's avatar
    Juramirez
    Resolver I
    8 years ago

    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

    • parry2k's avatar
      parry2k
      Super User
      8 years ago

      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

      • Juramirez's avatar
        Juramirez
        Resolver I
        8 years ago

        parry2k I'm adding it as a column, as a measure it doesn't see my column value. How can I do that?