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. 

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?

    • parry2k's avatar
      parry2k
      Super User
      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. 

      • Juramirez's avatar
        Juramirez
        Resolver I
        8 years ago

        Thanks parry2k. It's working! :D