Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Allow Users to Override Measure Logic that Filters the Table

I have a table which matches companies based on similarity. It is constructed so that for each company, it will match against every other company, and give those matches a rank. eg. Let's call thi...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Anonymous - The short form is:

     

    Measure =
  SWITCH(SELECTEDVALUE('DisconnectedTable'[Column]),
    "Option 1", <calculation one way>,
    "Option 2", <calculation a different way>
  )
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks amitchandak, the rank in this case is static (calculated outside powerbi and then brought in). So I guess what I'm trying to get at is if I have measures that filter on a column like that, but I'd also like a user to be able to override that and instead choose which rows they personally want to filter on, how do I code that into a measure? That it should let the user override it's filter if they want to?