Forum Discussion
Added another column to a matrix visual based on values in matrix
I have a table that is aggregated based off a table in a matrix visual.
| Final Job Type | Job Ct | Job Cost | |
| PA | 420 | 300,000 | |
| PA-Exclude Top 10% | 378 | 230,000 |
I want to add another column that takes out the top 10% of the job ct, and buy doing this is will change the total cost as well for those jobs. How do I do this in a matrix visual without manipulating the actual data table?
3 Replies
- mahoneypat
Microsoft Employee
You could make your measure and use the Show On Rows feature of the matrix visual. It would also put your other two measures on rows as well FYI.
https://datasavvy.me/2017/08/10/you-can-now-put-values-on-rows-in-power-bi/
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
- v-easonf-msft
Community Support
Hi, chel4782
Could you please tell me whether your problem has been solved?
If yes, you could accept the helpful answer as solution.For now, there is no content of description in the thread. If you still need help, you can provide a simple data sample and expected results, so that we can make a demo for your reference.
Best Regards,
Community Support Team _ EasonNo, I can not add DAX calculation to each row in table. I need to add it to visual that is an aggregation of the rows in the table. I do not want a value for each row in the underline table.
