March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
114 | |
76 | |
57 | |
52 | |
44 |
User | Count |
---|---|
168 | |
116 | |
63 | |
57 | |
50 |