Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey Everyone!
i would like to ask about matrix table. i want col. to show sum of Vol. fail case in itm_sts_mod but after i made, condition show duplicate table of fail case
In the fail case, You can see itm_sts Col. have 2 status which is Cancelled and NPASS so that's why data show dulipated
Hi buddy,
I don’t quite get what you’re trying to do here.
Are you trying to add an extra column in a table to count how many cases has Failed or NPASS as in status? If yes, what is the table structure that you are using and what are the combination you have used to create your matrix “Rows, Columns and Values”? Usually screenshots would do great help with these kinds of scenarios.
If the above is not useful or you think it is irrelevant perhaps you consider rephrasing your query?
Kinds regards
Hicham
Hey Hicham,
I'm trying to add colume to count how many cases has Failed in status
actually i have 3 conditions of fail case
Regards
Amp
Hi Again,
And please bare with me 🙂
Can you please post a screenshot of a table showing the view that you are trying to calculate?
e.g.:
I hope this makes sense 🙂
Kind regards
Hicham
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |