How to show % of total - on subgroups

[DennisSchlein]

Hi 

I'm fairly new to PBI. I have created a table with a status code - that represents the values from the bottom table:

Status Code	Status Text
1	1
2	2
3	3
4	4
5	5
6	6
7	7
8	8
9	9
10	10
1000	10+
1001	Invalid Data
1002	No CMR Scan
1003	Not Shipped
1004	Not Delivered
1005	Missing SLA Leadtime
1006	Delayed
1007	On Time

In my raport I want to show 2 group - Active shipments (Status Code: 1000, 10004, 1006 and 1007. That part is easy because I can just apply a filter to my visual.

Then I want to show data with issues- Status: 1001, 1002, 1003 & 1005. But as a % of the total. But if I apply a filter on my visual I get it as a % of the filtered total.

How to come around that?


Kind regards,

[DennisSchlein]

Hi @v-xiandat-msft  - Sorry for the late reply.
This is exactly what I was looking for. Thank you very much 🙂 

[v-xiandat-msft · Accepted solution]

Hi @DennisSchlein ,

Below is my table:

The following DAX might work for you:

Shipments with Issues = COUNTROWS(FILTER('Table', 'Table'[Status Code] IN {1001, 1002, 1003, 1005}))


Measure2 = CALCULATE(COUNTROWS('Table'),ALL('Table'))



total % = DIVIDE([Shipments with Issues],[Measure2],0) 

The final output is shown in the following figure:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.