Forum Discussion
Solved
Summarize Audits by PO #
Hello, I am trying to summarize a list of audits by PO#. There are numerous audits with the same PO#. I need to be able to consolidate the audits with the same PO# and report how many total units w...
Using a DAX Calculated Table
SummaryTable =
SUMMARIZE(
AuditTable,
AuditTable[PO#],
"TotalUnitsAudited", SUM(AuditTable[UnitsAudited]),
"TotalDefects", SUM(AuditTable[Defects])
)This SummaryTable will contain the consolidated data, showing one row per PO# with the total units audited and total defects.
💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
Using a DAX Calculated Table
SummaryTable =
SUMMARIZE(
AuditTable,
AuditTable[PO#],
"TotalUnitsAudited", SUM(AuditTable[UnitsAudited]),
"TotalDefects", SUM(AuditTable[Defects])
)
This SummaryTable will contain the consolidated data, showing one row per PO# with the total units audited and total defects.
💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
This worked! Thank you SO much!!!