Make a check list of values existing or not for a product

[Marco57]

Hello,

I have a table of products :

Product_Name

A

B

C

and a table of product definition where I am going to identify properties of each product:

Product_ID | Property

A                      Color

A                      Shape

A                      Stiffness

B                       Color

C                       Shape

C                       Stiffness

What I would like to have is a checklist of all distint properties and when I select in slicer a specific product, I can see in this table if property is defined or not (true or false): let's say prodct C is currenlty selected:

Distinct_properties | measure_propety_defined

Color                             False

Shape                            True

Stiffness                         True

I tried with CONTAINS but can only work within same table and tried also DISTINCT but did not figure a way to do what I need.

Many thanks in advance for any support

[speedramps · Accepted solution]

Consider this solution and remember we are BI community voluntrees so please click the thumbs-up for me taking the trouble to help you and then accept the solution if it works.  Thank you !

Click here to see a demo solution 

In edit query right click on the 2nd table and select Reference.

Call the new table Properties

Edit the Properties table

Right click on the property column and remove other columns

Right click on the property column and remove duplicates

In relationships, delete all relationships

The create Product 1:M Fact relationships

The create Property 1:M Fact relationships

Create measure

Defined = IF( ISEMPTY(Facts), "False", "True" )

Add a matrix visual with

Row = Products[Product Id]
Column = Properties[Row = Products[Product Id]
Values = Defined

Click here to see a demo solution 

[Marco57]

@speedramps The matrix visual is indeed a smart solution ! Many thanks for your kind support.