Filter value without relationship

[Anonymous]

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 [Selection] will be the filter.

If I filter Selection="Yes", I only want to see A+B value

If I filter Selection="No", I olny want to see C value.

If I filter Selection="Maybe", I olny want to see D value.

How can I achieve it? Thanks!

Regards,

BK

[S_JB]

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]

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]

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