Forum Discussion
TCatron18
1 year agoHelper II
If Statement in Measure
Hello! I've looked around but not finding a solution that works for my situation. I am trying to add a row into a matrix that has a static value for a specific column. Below is the current s...
- 1 year ago
Add selectedvalue()
IF( selectedvalue('Awards'[Sender's Sr Business Unit] ) = "xSystem Generated",
d_m_LNK
1 year agoSuper User
Completely agree with Deku. You are getting the error because currently you are referencing the entire column of values of the 'Awards'[Sender's Sr Business) Unit] column. Adding SelectedValue() around the column gives you a single value to evaluate in the statement within the filter context. This has happened to me so many times 🙂