How to slice Matrix Table with help of slicer(Measure)

[wagau999]

I have two tables Product and Isavailable. "Product" table has 6 level of Product Hierarchies and other Table "IsAvailable" has Product availability flag. I have created Measure calculating availability for each Product. Power BI Report has below Matrix visual. 

I need to slice the Matrix visual depending on selection of Product availability(Yes/No).  Kindly help.

[MAwwad]

Filtered Data:= CALCULATE(SUM(Product[Sales]),FILTER(IsAvailable,IsAvailable[Availability] = SELECTEDVALUE(IsAvailable[Availability])))

This measure uses the "FILTER" function to filter the "IsAvailable" table by the selected value of the "Availability" column, and the "CALCULATE" function to modify the data that is being displayed in the Matrix visual based on that filter. It will use the selected value from the column "Availability" from the table "IsAvailable", and filter the Product table to sum only the rows where the availability is the one selected.

You can then use this measure in your Matrix visual instead of the original measure. Also, you will have to have a relationship between the two tables.

[wagau999]

Hi DataSlayer,

Thanks for looking and helping here!

I am sharing the sample Power BI file here for referance. So you can understand what is the issue here. In my Product Table I have 6 columns for Product column so relationship between many column to one column is required here which i am not aware of. So technically we can create one active relationship and other inactive and with Userelationship, but that seems difficult here.  Hope you will look into it and provide the solution.

One Drive link: https://onedrive.live.com/?id=88ad0d9fb4f11e3c%21106&cid=88AD0D9FB4F11E3C

Goggle Drive link: https://drive.google.com/file/d/1wgSn3rd98fIj2OXUfMeAdFzK6o1dsBsf/view?

Thanks,

Gaurav