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.
Hello,
I would add summary colums to the table (N_PASS and N_FAIL). There is an example in the data file. These colums are the count of the status grouped by SERIAL_NUMBER and OPERATION.
I can't create a new table with the summary. With a new table some visual filters are not working properly.
Thank in advance,
Solved! Go to Solution.
HI, @amateu
Just use these two formulae to create two columns:
new N_PASS = CALCULATE(COUNTA('Table'[STATUS]),FILTER(ALLEXCEPT('Table','Table'[OPERATION],'Table'[SERIAL NUMBER ]),'Table'[STATUS]="PASS"))+0
new N_FAIL = CALCULATE(COUNTA('Table'[STATUS]),FILTER(ALLEXCEPT('Table','Table'[OPERATION],'Table'[SERIAL NUMBER ]),'Table'[STATUS]="FAIL"))+0
Result:
Best Regards,
Lin
HI, @amateu
Just use these two formulae to create two columns:
new N_PASS = CALCULATE(COUNTA('Table'[STATUS]),FILTER(ALLEXCEPT('Table','Table'[OPERATION],'Table'[SERIAL NUMBER ]),'Table'[STATUS]="PASS"))+0
new N_FAIL = CALCULATE(COUNTA('Table'[STATUS]),FILTER(ALLEXCEPT('Table','Table'[OPERATION],'Table'[SERIAL NUMBER ]),'Table'[STATUS]="FAIL"))+0
Result:
Best Regards,
Lin
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |