Forum Discussion

t_guet01's avatar
t_guet01
Icon for Helper I rankHelper I
5 years ago
Solved

How do I use Group By in DAX with text values?

Hey guys,   I want to Group By products in DAX and add columns with text value. The products have a unique ID, however the additional columns are not unique.    Setting: Our client has sent us a ...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi t_guet01 ,

     

    I have found the problem. Measure 2 is not grouped by product. Please refer to my .pbix file again.

     

     

    Best regards,
    Lionel Chen

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

t_guet01's avatar
t_guet01
Icon for Helper I rankHelper I
5 years ago

Dear v-lionel-msft ,

thank you very much for your reply. 

My original data is much bigger, which however I am not able to share to protect my clients data. When adding a third product, say 789, with Headquarter Supplier NationalEntity1, your Measure 2 starts failing, since it says "NationalEntity2" for each row.

 

Do you have any solution for that?

 

Thank you very much.


Best

Till

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi t_guet01 ,

     

    I have found the problem. Measure 2 is not grouped by product. Please refer to my .pbix file again.

     

     

    Best regards,
    Lionel Chen

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