Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

analysis by grouping

Hi everyone,   I'm wondering if there is a way to use DAX to get an analysis based on a grouped variable. For example, I have two columns: Case # & drug. Each drug in a specific case is a new row b...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    This measure works

    Measure = CONCATENATEX(VALUES(Data[Drug]),data[drug]," ")

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Share some data and show the expected result.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    What my data currently looks like:

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    How I need the data to look:

     

     

     

     

     

     

     

    Thanks!

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      3 years ago

      Hi,

      This measure works

      Measure = CONCATENATEX(VALUES(Data[Drug]),data[drug]," ")

      Hope this helps.