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
rajendraongole1
Super User
Super UserHi shaylacrowe -By default, In Power BI will sum the Units Audited and Defects for each PO#. It will display the totals in the table, grouped by PO#
can you please share some sample data, so that we can check and analyse the same.
if you