How to show only if the two data selected in slicer match with my data?

[Anonymous]

Hi! So, I have the app name data along with the app category.

Some applications may be in the same application category, for example, A-1 and A2 are both included in the G50B category. I created a slicer, with a field consisting of the application name and category. I want to display sales when the application name and category match the one I selected.

The problem is that when I select A1, G50B in the slicer, the sales displayed are for all data that has A1 and G50B in it, including A2, A4, A6 and A8 applications because they are also in the G50B category. How do I filter to show sales data only when two selected data in slicers match with my sales data (only sales for A1 G50B)?

Here's the data i used.
Data App Sales 

[MahyarTF]

Hi,

If I am not mistaken, you created the column that is included the App Name and App Category.

If it is when you develop the Slicer on the specific column, the data should be filtered by the selected data.

I created the column and put the slicer on it :

When I selected each one, the data is filtered :

Please correct me if I am wrong or misunderstood.

[Anonymous]

Thankyou for your reply!

Yeah you got it right, the data should be filtered by the two selected value on slicer. The difference from your demo is i got two field (app name and category) in one slicer, like the photo below. Even though i try to select only one app from the category, for example A4 in category G50B, It also shows sales for A4 in another category, which is G51.

How do i filter for chart to show only A4 in category G50B?

Thankyou in advance!

[MahyarTF]

Hi @Anonymous 

It is a bit wired for me,

this is my result :

1) when nothing is selected :

2) When I select the 'A-4' in slicer :

May I ask you to share your sample PBIX file somewhere, maybe I could figure it up ?

[Anonymous]

Here's the pbix i use. I wondering if it has something to do with cross filter driection. I used direction "both" for the relationship between app name and app category.

Thanks in advance!

App sakes File 

[MahyarTF · Accepted solution]

Hi @Anonymous ,

As I saw you bring the "App Name" and "App Category" from the "Sales" table to the Table Visual, but in your slicer, there are belong to the App_Date table. Otherwise, in your data model, you have more than one relationship between tables and as you know just one relation could be active each time (For your DM is on "App Name".

When we click on the "A-4" value in Slicer, the relation brings us the values that are connected via the "App Name = "A-4"".

It means, it is similar when we put a slicer on the Sales[App Name] and select the "A-4" value.

in my opinion, you need to develop a slicer on the Sales[App Category] and Sales[App Name] (that is the easiest solution), or create two other columns based on the value on the App_date table in Sales with UseRelationShip Dax Function (a bit complicated and not sure how it is possible for non-countable fields).

https://dax.guide/userelationship/

The existing solution :

My Solution :

Appreciate your Kudos and Please mark it as a solution if it helps you