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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
PereJoan
Frequent Visitor

How to show a list of all parts that are related to some selected products and not to others?

Hello to you all and thanks for all the help you could bring on this 🙂

 

I've tried to find any other thread, but I'm not sure there is one for this doubt.

Sorry if I duplicate and/or misplaced this question.

 

I have a table where I relate Products and Parts, each product uses varios parts and each part, could be (or not) used in many products.

ProductsParts
Prod-A

Part-1

Prod-APart-3
Prod-APart-4
Prod-BPart-2
Prod-BPart-3
Prod-CPart-1
Prod-CPart-4

 

The goal we have is to have a dynamic list that only shows the parts that are ONLY related to the products selected on a visual.

As if for example, we have product A and C selected, we show only Parts 1 and 4 (because Part-2 is not in Prod-A nor Prod-C and Part-3 is in Prod-A but also in Prod-B, and Prod-B is not selected in the visual)

 

If anyone could help us with it it would be really apreciated.

Thanks in advance!

 

 

UPDATE_____________________________

PBIX file here:.

https://drive.google.com/file/d/1myxBVZUa0MzUzitUFyEiaAFWOMIHIEl_/view?usp=drive_link

 

I think that might help to understand a bit better what I was trying to say. Sorry if I wasn't clear enough ^^

I'm trying to create a DAX similar to this:


PereJoan_0-1712895575156.png

 

 

But I don't know why is not working (Also I had to put a CONCATENATEX because otherwise when I added this measure to a table it kept saying that was containing more values than expected (it expected 1) but the whole point of the measure is to create those many values.

 

I'm not sure what I'm doing wrong here.

 

It would be a great help if somebody could give me a hint or something

Thanks!


6 REPLIES 6
ThxAlot
Super User
Super User

Simple enough,

ThxAlot_0-1712503481734.png



Expertise = List.Accumulate(


        {Days as from Today},


        {Skills and Knowledge},


        (Current, Everyday) => Current & Day.LeanAndPractise(Everyday)


)



Hi @ThxAlot !

 

Thanks for the help, but it's more or less like @Jihwan_Kim  solution.


At least the PBIX file you attached uses the slicer as normal. If I select Prod B for example, shows part 2 and 3. But because 3 is also in Prod A, we shouldn't be displaying it in the list, the list when just Prod B is selected in the slicer should be just Part 2, since it's the only part related to Prod B and not to anyone else.

Same thing happens when selecting Prod C (shows Part 1 and 4, instead of just part 4) or when selecting multiple Prods like Prod B and C

I'll add to the description a better explanation

Thanks again 

PereJoan_0-1712895205354.png

 

AnalyticsWizard
Solution Supplier
Solution Supplier

To create a dynamic list in Power BI that only shows the parts related to the selected products, you...1. Here’s an example of how you might write this measure:

DynamicPartsList = 
CALCULATE(
    VALUES(Table1[Parts]),
    FILTER(
        ALL(Table1),
        COUNTROWS(
            FILTER(
                VALUES(Table1[Products]),
                CALCULATE(
                    COUNTROWS(Table1),
                    ALLEXCEPT(Table1, Table1[Products])
                ) > 0
            )
        ) > 0
    )
)

In this measure, Table1 is the name of your table. This measure creates a list of parts that are related to the selected products. The ALL function is used to remove any filters that might limit the rows being evaluated. The VALUES function is used to get a list of the selected products, and the FILTER function is used ...1.

Please replace Table1 with your actual table name. If you need further assistance or have more specific requirements, feel free to ask! 😊

Hi @AnalyticsWizard , thanks to you as well.

 

But I do not know why is not working for me this measures. they just list the parts directly related to the products selected, nothing more nothing less.

Jihwan_Kim
Super User
Super User

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

 

Jihwan_Kim_0-1712464751480.png

 

 

Parts list expected result: =
VAR _condition =
    CALCULATE ( COUNTROWS ( 'Product' ), ALLSELECTED ( 'Product' ) )
RETURN
    INT (
        _condition
            = CALCULATE ( COUNTROWS ( Data ), ALLSELECTED ( 'Product'[Products] ) )
    )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


Hi @Jihwan_Kim Jihwan_Kim!

Thanks for the help ^^ Sadly, it has not quite the same behavior as I've tried to describe, my bad.

I'll try to clarify on this.

At least the PBIX file you attached uses the slicer as normal. If I select Prod B for example, shows part 2 and 3. But because 3 is also in Prod A, we shouldn't be displaying it in the list, the list when just Prod B is selected in the slicer should be just Part 2, since it's the only part related to Prod B and not to anyone else.

Same thing happens when selecting Prod C (shows Part 1 and 4, instead of just part 4) or when selecting multiple Prods like Prod B and C

Could be that?

Thanks again 🙂

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.