Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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 _ Eason
No, 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.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |