Forum Discussion

Tinus1905's avatar
Tinus1905
Resolver I
2 years ago

Filter slicer with IF function

Hello,    I want to use my slicer and when I select the value "Cars" then the output in my card has to be "Cars measure", when I select the value "Music" then the output in my card has to be "Music...
Need Help
AilleryO's avatar
AilleryO
Memorable Member
2 years ago

Hi,

Be carefull with FILTER function which is an equivalent to CALCULATETABLE, so it means it returns a table which is not a valid argument for IF function.

You just need your test :

Filter = IF( 'Sample Table'[Value3] = "Cars", [Cars measure], [Music measure])

Hope it helps

  • Tinus1905's avatar
    Tinus1905
    Resolver I
    2 years ago

    With thisd I get a error: 

    A single value for column 'Value3' in table 'Sample Table' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.