Copy text from within table

[deisterBI]

Hi,

I would like to refference the Main component within a parts list
The mother article doesnt hold stock but the doughter article does. I would like to have the name of the doughter article in the same row as the mother article to link it with my purchasing table.

Article	parts	does hold stock	qty ordered	Main Article
12345	ABCD	1	1000	ABCD
12345	12345	0	0	ABCD

The goal would be to achive what is stated in the colum "main Article"

Any Ideas :)?

[Anonymous]

Hi @deisterBI ,

Please try below steps:

1. below is my test table

Table:

2. create measure with below dax formula

Main Article =
VAR max_sale =
    MAXX ( ALL ( 'Table' ), [Sales] )
VAR article =
    CALCULATE (
        MAX ( 'Table'[Doughter article] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Sales] = max_sale )
    )
RETURN
    article

3. add a table visual with fields and measure

Please refer the attached .pbix file.

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[deisterBI]

just to make this more transparant, with more than one mother article:
the collum main article would again be my desired outcome.

mother article	Doughter article	sales	main article
car	door	2	tires
car	tires	4	tires
car	wheel	2	tires
truck	door	2	windshield
truck	tires	4	windshield
truck	wheel	2	windshield
truck	windshield	6	windshield

[Anonymous]

Hi @deisterBI ,

You just need to adjust my measure simply, please try below dax formula:

Main Article =
VAR cur_monarticle =
    SELECTEDVALUE ( 'Table'[Mother article] )
VAR tmp =
    FILTER ( ALL ( 'Table' ), 'Table'[Mother article] = cur_monarticle )
VAR max_sale =
    MAXX ( tmp, [Sales] )
VAR article =
    CALCULATE (
        MAX ( 'Table'[Doughter article] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Sales] = max_sale )
    )
RETURN
    article

Please refer the attached .pbix file.

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[deisterBI]

amazing.
and if I wanted to have that same result, as a collum in the table itself not as a messure ?

I would need to have that field in order to link it in the datamodell with another table.

[Anonymous · Accepted solution]

Hi @deisterBI ,

If you want to add a new column, you also just need to adjust my measure simply, please try below dax formula:

Article Column =
VAR cur_monarticle = 'Table'[Mother article]
VAR tmp =
    FILTER ( ALL ( 'Table' ), 'Table'[Mother article] = cur_monarticle )
VAR max_sale =
    MAXX ( tmp, [Sales] )
VAR article =
    CALCULATE (
        MAX ( 'Table'[Doughter article] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Sales] = max_sale )
    )
RETURN
    article

Please refer the attached .pbix file.

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[deisterBI]

@Anonymous 
Now that i ran some tests, i came across a problem:
when another daughter article in another part list, has the same sales as the maximum one in another part list, those get switched up at times.

The only link between both datasets seems to be the qty in sales.
I thought that the variables you defined, prefented that exact result, but apparently it is possible that the formula only matches the daughter article number based on the max sales and somehow is ignoring the mother article parameter.

i am super lost here, if you can help once again , that would be great 🙂

[deisterBI]

you made my day , thank you so much !

[deisterBI]

HI @Anonymous,

thank you for taking the time to help me.
So far , I am not getting the results needed, and its probably because there are multiple "mother articles".

the messure now gives me the most selling "doughter article" but its not correlating with the "mother article"

So for all mother articles I get the same result which is the most selling doughter article. (even when that part isnt in the part list of the mother article)
i think we are close , in case I didnt make any mistake converting the abstract formula, there is missing the part where the mother article is beeing refferenced ?

Thanks again for your help

[deisterBI]

Mother article	Doughter article	Sales	"main Article"
car	tires	2	wheel
car	wheel	4	wheel
car	door	2	wheel

maybe I need to descripe the situation better ?

I would need the result as in the collum "main article"
I want to add the article name of the most "contributing" article of a data group