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. 

skocheta's avatar
skocheta
Advocate I
8 years ago

Thanks parry2k, That works. Could you explain How/Why :)

I was assuming that it was the else condition which was causing issue.

 

And on a different/related note.. Could you suggest a way so that this works with Formatting.

Alternately I created a Measure which displays selected Currency in a column, There the issue is when user does not select any currency (hence would ned a default option).

parry2k's avatar
parry2k
Super User
8 years ago

skochetaWhat would be the default option if no currency is selected?

  • skocheta's avatar
    skocheta
    Advocate I
    8 years ago

    parry2k, Euro,i was trying to use lastnonblank...

    Also, Could you help how format was causing the issue and if there can be a work around.

    My users would like to see which currency the figures are in (especially when they export to excel)