Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Get multiple columns in one columns

Hi All,

 

I have calculated Maximum and Average measure. Please find the below screenshot:

For get this metrics, I have used formula 

1. Max = MAXX(ALL('Table'[Brand]),[Sum_Traffic])

2. Average = Averagex(ALL('Table'[Brand]),[Sum_Traffic])

 

My query is : Can we convert this table as 

 

Thanks

Shipra

 

DAX Calculation
Multiple columns
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

    You can create a matrix visual and refer to the screenshot below to drag the corresponding fields to the visual.

    If the above one still can't help you get the desired result, please provide some raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

    How to upload PBI in Community

    Best Regards

5 Replies

  • Whitewater100's avatar
    Whitewater100
    Solution Sage
    4 years ago

    Hi:

    You can kinda do what you want but can't put measures in columns. Please see format options for matix to get the look below:

     

    I hope this helps!

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi All,

     

    Is there any way to return multiple sub-columns into one column?

    I used the below code:

    Parent_Column =
    Var Sum1 = SUM('RN Dashboard'[Traffic Out])
    var max1 = MAXX(ALL('RN Dashboard'[Brand]),[Sum_Traffic])
    Var Avg1 = AVERAGEX(ALL('RN Dashboard'[Brand]),[Sum_Traffic])
     
    Return
     
    Please let me know if way is available.
     
    Thanks
    Shipra
    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Anonymous ,

      What does the original data in the table “RN Dashboard”  look like? Could you please provide some sample data from the table “RN Dashboard”  in Text format? Is Key Attributes a column that actually exists in the table? If so, you can create your matrix with the following settings...

      1. Create a matrix visual

      2. Toggle off "Stepped out" option under the tab Row headers in Format pane

      If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

      How to upload PBI in Community

      Best Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi All,

     

    Thanks for the help.

    I want multi-level matrix as below format.

    For example: In under Traffic column I need Sum, max and average value.

     

    Traffic
    SumMax

    Average

     

    Thanks

    Shipra

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Anonymous ,

      You can create a matrix visual and refer to the screenshot below to drag the corresponding fields to the visual.

      If the above one still can't help you get the desired result, please provide some raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

      How to upload PBI in Community

      Best Regards