Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Marco57
Helper III
Helper III

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

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

 

1 ACCEPTED SOLUTION
speedramps
Super User
Super User

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 

 

 

View solution in original post

2 REPLIES 2
speedramps
Super User
Super User

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 

 

 

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.