Forum Discussion

deisterBI's avatar
deisterBI
Frequent Visitor
3 years ago
Solved

Copy text from within table

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
    deisterBI
    Frequent Visitor
    3 years ago

    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's avatar
    deisterBI
    Frequent Visitor
    3 years ago

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

     

    mother articleDoughter articlesalesmain article
    cardoor2tires
    cartires4tires
    carwheel2tires
    truckdoor2windshield
    trucktires4windshield
    truckwheel2windshield
    truckwindshield6windshield
    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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's avatar
        deisterBI
        Frequent Visitor
        3 years ago

        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.