Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I saw a similar post but I couldn't get the result to work for my data.
I have data that I simplified below. There are multiple serial #s and test results. Some tests pass the first time (#1,2,3,4). Some pass on a retest (#5,8). Some fail a restest (#6,12). Some fail and were not retested (#9,10,11). Some were tested and passed every time (#7). I would also like to get the results in the shown form which I'm sure is easy but I'm still learning
Serial # | Test result | |||
1 | pass | |||
2 | pass | |||
3 | pass | |||
4 | pass | |||
5 | fail | |||
5 | fail | |||
5 | pass | |||
6 | fail | |||
6 | fail | |||
7 | pass | |||
7 | pass | |||
8 | fail | |||
8 | pass | |||
9 | fail | |||
10 | fail | |||
11 | fail | |||
12 | fail | |||
12 | fail | |||
12 | fail | |||
12 | fail | |||
pass first time | pass restest | fail retest | fail no retest | pass multiple tests |
4 | 2 | 2 | 3 | 1 |
Solved! Go to Solution.
Hi,
You can create this kind of category measure to solve this issue:
Table (7) is just the test data.
Then create additional table like this:
Create this kind of measure:
End result:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Proud to be a Super User!
Hi,
You can create this kind of category measure to solve this issue:
Table (7) is just the test data.
Then create additional table like this:
Create this kind of measure:
End result:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
21 | |
17 | |
15 | |
11 | |
7 |
User | Count |
---|---|
26 | |
25 | |
12 | |
12 | |
12 |