Forum Discussion

Praj's avatar
Praj
Icon for Helper I rankHelper I
3 years ago
Solved

How to aggregate rows based on columns

Hello Everyone, 

 

I have the below source table where each account has the RAG status. 

I am trying to create a new output table from the above pasted table to get the unique account name and respective status. Below is the output table I am looking for using DAX. 

I tried the lookup however, due to accounts associated with multiple status it throwed an error. Any approach on this problem will help me a lot.

 

TIA

 

Cheers,

Praj

 

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Praj ,

     

    Please try:

    Table 2 = DISTINCT( SELECTCOLUMNS('Table',"Account",[Account],"Status",[Status]))

     

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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Praj ,

     

    Please try:

    Table 2 = DISTINCT( SELECTCOLUMNS('Table',"Account",[Account],"Status",[Status]))

     

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

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    3 years ago

    Hi Praj 

    In case of multiple status for one account, which do you expect to return?

    • Praj's avatar
      Praj
      Icon for Helper I rankHelper I
      3 years ago

      Hi FreemanZ , 

      Thanks for your response. 

      In case of multiple status, I am expecting the worst case. (If single account has red and green status, I am looking for red as the final status in my output table)