Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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,
Solved! Go to 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.
Hi @v-xiandat-msft - Sorry for the late reply.
This is exactly what I was looking for. Thank you very much 🙂
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.
User | Count |
---|---|
107 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |