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. Av...
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

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