Forum Discussion
Filter with condition
hi, i'm trying to get a filter that automatically selects me two field, example, I want if I select the "TOWN HALL" field, the other corresponding field "TOWN HALL - TEMPERATURE" is automatically se...
Yes Tahreem24 ,
Good solution also.
If you want to go down the Calculated column route the following DAX should work for you.
High Level Selection = IF(CONTAINSSTRING(Table1[Selections],"-"),LEFT(Table1[Selections],FIND("-",Table1[Selections])-2),Table1[Selections])
(Obvious disadvantage to this solution is that you will strip out anything after the "-" character. So this will work for all rows in your example, however will give undesirable results if your row contains 2 or more instances of the "-")
🙂 sduffy
thanks for the tip but it can't work for me, because they can be given for example:
TOWN HALL 1
TOWN HALL 2
TOWN HALL - TEMPERATURE
If I select 1 I must restore 1 + temeratua, and if I select two I must take 2 + temperatures