- Forums
- Get Help with Power BI
- Desktop
- Service
- Report Server
- Power Query
- Mobile Apps
- Developer
- DAX Commands and Tips
- Let's Talk Data
- Custom Visuals Development Discussion
- Community Support
- Community Information
- Community Accounts & Registration
- Using the Community
- Community Feedback
- Training and Consulting
- Dashboard in a Day
- EdX Specific Training Discussion Forum

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Microsoft Power BI Community
- Forums
- Get Help with Power BI
- Desktop
- Median of Row Column in Matrix

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

ThomasDay

Established Member

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

08-12-2016
11:40 AM

Hello Fellow Dax'ers

It sure seems like I should be able to do this...but I'm not seeing it with the things I've tried.

I have a selection of records--that serve as columns in a matrix. The rows are different performance metrics. In essence, this is a side-by-side display/comparison of the columns. it would be VERY helpful to have a median column which shows the 50th percentile value for the row. Below is the matrix. For example--instead of the total column, a median or any percentile calc for that matter. Next to the snip of the matrix is the field well for the visual. I can't put the rowmedian measure into the the rows or columns well--only the values well which isn't helpful as you can see in snip 3. Any ideas? Tom

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

v-micsh-msft

New Contributor

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

08-18-2016
07:34 PM

Hi ThomasDay，

The total Column under the Matrix has the function to compute the Median, but the Total title won't change. I think I have showed how to change the Sum to the other compute methods,

To set the Total column to compute Median, we need to open the dropdown icon of the item in the Value fields, where would allow to choose the methods, then select the methods we need. Values in total should be changed after selection.

Under the pen icon, we could choose whether to show both column total and row total.

By the way, currently I have no idea adding a column which would show the Median column as the total column is possible under Matrix.

Regards

6 REPLIES 6

jahida

Established Member

Re: Median of Row Column in Matrix

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

08-12-2016
01:15 PM

This seems a bit simplistic, but can you just get rid of the initial measure and only use the Median measure you wrote?

ThomasDay

Established Member

Re: Median of Row Column in Matrix

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

08-12-2016
02:20 PM

@jahida Yes, that doesn't really get me to where I'm hoping to go. The point of the matrix is the side by side comparisons...I was thinking a median column would help the viewer understand each column more quickly and intuitively than having to size up the values across the line. Anyone else have a way to go with this?

Tom

v-micsh-msft

New Contributor

Re: Median of Row Column in Matrix

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

08-17-2016
02:07 AM

Hi ThomasDay,

If you would like to show the Median of the Metric Value, we could just select the option in the dropdown list, there are Average and Median could be selected, and I think a measure should not be necessary here. Please take a try and see if this would meet the requirements.

If any further assistance needed, please feel free to post back.

Regards

ThomasDay

Established Member

Re: Median of Row Column in Matrix

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

08-17-2016
06:32 AM

@v-micsh-msft Thanks for the suggestion. I am looking to add a column which is like the **Total Column**--but is a Median rather than a Sum. If I could set the Total Column to compute a Median, that would be perfect.

Thanks again....Anyone have another idea?

v-micsh-msft

New Contributor

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

08-18-2016
07:34 PM

Hi ThomasDay，

The total Column under the Matrix has the function to compute the Median, but the Total title won't change. I think I have showed how to change the Sum to the other compute methods,

To set the Total column to compute Median, we need to open the dropdown icon of the item in the Value fields, where would allow to choose the methods, then select the methods we need. Values in total should be changed after selection.

Under the pen icon, we could choose whether to show both column total and row total.

By the way, currently I have no idea adding a column which would show the Median column as the total column is possible under Matrix.

Regards

ThomasDay

Established Member

Re: Median of Row Column in Matrix

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

08-19-2016
06:23 AM

@v-micsh-msft Interesting..You know this actually works since each row is the value from a single record. That means the row values don't change when I change the row calc to Median. The total column is the median of the row values (unchanged) which is exactly what I was looking for. Thanks for keeping up with this thread! Tom