Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
66 | |
62 | |
62 |
User | Count |
---|---|
199 | |
120 | |
110 | |
79 | |
69 |