Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
I have a Matrix with Customer Name, Customer Number, Order Type, order count per type with a subtotal by customer.
Date Slicer and Customer Number Slicer - Filtering on a specific group or order statuses
How do I write a new measure to get the % by order type for each customer (500/557, 15/557, .2/557, 40/557) "Show value as" will calucate based on the whole column, not each individual customer.
| Customer Name | Customer Number | Order Type | Distinct Order Count | How do I get: % by order type |
| Customer1 | 12345 | Copied | 500 | 90% |
| Freight | 15 | 3% | ||
| Quote | 2 | 0% | ||
| Scanner | 40 | 7% | ||
| Total | 557 | 100% | ||
| Customer2 | 12246 | Copied | 25 | 18% |
| Freight | 1 | 1% | ||
| Manual | 50 | 35% | ||
| Quote | 20 | 14% | ||
| Scanner | 45 | 32% | ||
| 141 | 100% |
Have been reearching solutions for a while and trying various measures but can't quite get the result I need.
Thanks.
I found my own solution without having to create new measures. Instead of my order type being in a ROW, I moved it to Column. This then allowed me to to have Value Count of Order and Value Show as % of Row.
Check out this forum entry: https://community.powerbi.com/t5/Desktop/Unable-to-Get-Correct-Percentage-when-Filter-or-Slicer-Used...
They accomplished what you are trying to do.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!