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 are in EUR and others are in USD) but even if in my column Currency the transaction is in USD the column with the corresponding value in EUR exists (EURAmount), the same happens if the column Currency is in EUR -->(USDAmount). What I want to do is that when I select USD in my slicer, in a card visual i can see the sum of the column USDAmount and when I select EUR I can see the sum of EURAmount. The problem is that when i'm filtering this if I select USD it only shows me the values that are in that currency in the column Currency (It changes the sum but only for the values that have in my column Currency that value, not for all) Is possible to change the amount?

This is my current measure;

Total = IF(Table1[Currency]="USD",Table1[USDAmount],Table1[EURAmount])

 

Thanks

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. 

12 Replies

  • 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