cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
beekee
Helper IV
Helper IV

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 [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!

beekee_0-1626160859730.png

 

 

Regards,

BK

3 REPLIES 3
S_JB
Resolver III
Resolver III

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"))

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

Hi,  @beekee 

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

 

 

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!