Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Filter value without relationship

Hi All,   I have two tables: Fact_Actual and Options. These two data tables have no relationship at all. In the dashboard, I will have a table and slicer. Table contains only [Value] and [Selectio...
Need Help
Show and Tell
S_JB's avatar
S_JB
Resolver III
5 years ago

You could create a new column within the Fact_Actual table. The logic is below:

 

Options =
IF('Fact_Actual'[Category]="C","No",
IF('Fact_Actual'[Category]="D","Maybe",
"Yes"))
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi S_JB , thanks for the reply. There will be more data than A-D, it will be troublesome to do this method

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    5 years ago

    Hi,  Anonymous 

    I'm not  sure what you mean by  "it will be troublesome".

    According to the information you provided,using the if statement to judge is the most direct solution.

     

     

    Best Regards,
    Community Support Team _ Eason