Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Summarize and refer Group Names to Order Numbers

Hey guys,   I'm searching for a measure because I can't do it in the advanced editor any more.   I have an older dataset where it worked by creating new columns in the advanced editor, which shou...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Hi Anonymous ,

     

    Create a measure or column as a tooltip. See if it meets your needs.

    Measure = 
CONCATENATEX(FILTER('Table',COUNTROWS(FILTER('Table',EARLIER('Table'[OrderNumber])='Table'[OrderNumber]))),'Table'[Team],"   ")

column = CONCATENATEX(FILTER('Table','Table'[OrderNumber]=EARLIER('Table'[OrderNumber])),'Table'[Team]," ")

     

    Sample .pbix

    If the problem persists,could you share the sample pbix via cloud service like onedrive for business?(Please mask any sensitive data before uploading)

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Hi Anonymous ,

     

    Try:

    team = RELATED('Group'[TeamName])

s_t = CONCATENATEX(FILTER('BaseData','BaseData'[OrderNumber]=EARLIER('BaseData'[OrderNumber])),'BaseData'[Team]," ")

    Sample .pbix has been updated

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

 

Create a measure or column as a tooltip. See if it meets your needs.

Measure = 
CONCATENATEX(FILTER('Table',COUNTROWS(FILTER('Table',EARLIER('Table'[OrderNumber])='Table'[OrderNumber]))),'Table'[Team],"   ")

column = CONCATENATEX(FILTER('Table','Table'[OrderNumber]=EARLIER('Table'[OrderNumber])),'Table'[Team]," ")

 

Sample .pbix

If the problem persists,could you share the sample pbix via cloud service like onedrive for business?(Please mask any sensitive data before uploading)

 

Best Regards,
Liang
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
    5 years ago

    Thank you V-lianl-msft that worked out pretty good!

     

    But a new problem occured:

     

    Since I linked the data for the team with another table over an many-to-many cardinality, I don't have the teams (AAA, BBB, CCC) but the Teammembers. Is there an easy way to get the Team names in the diagram or the DAX formula?

     

    The "Replace" function or the "Substitute" function seem not good for this purpose since there are a lot of teammembers, which are changing here and there. 

    • V-lianl-msft's avatar
      V-lianl-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi Anonymous ,

       

      Share a sample pbix file or paste some data and tell the relationship between the tables. In this way, I can be more clear of the scenario so that I can help you better.

      Please mask any sensitive data before uploading

       

      Best Regards,
      Liang
      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
        5 years ago

        Hi V-lianl-msft

         

        thank you for the fast reply.

         

        I advanced you original pbix file to show the problem. I unfortunatley can't share data in onedrive through my company account, so I made screenshots, which hopefully help.  (Is there another way to upload the pbix file to the forum?)

         

        Basedata

         

        Teammember to groupnumber

         

         

        Groupnumber to teamname

         

        Relationships

         

        The result (instead of the Teammembers, there should be the teamnames)

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I tried "Related"

       

       

      column = CONCATENATEX(FILTER('Table','Table'[OrderNumber]=EARLIER('Table'[OrderNumber])),RELATED'Table2'[Teamnames]," ")

       


      But it always shows me "Too many arguments were passed to the RELATED function. A maximum of 1 arguments are allowed for the function