Forum Discussion
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 were audited and how many defects there were total.
Thanks for your help!
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
4 Replies
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 LinkedInThis worked! Thank you SO much!!!
Hi shaylacrowe
You can create a measure in which you can get the total units of the audits.
Total Units = SUM(TableName[Units])
For the defect units, there must be some column (Defect) which says that this unit is a defect. Create another measure which says
Defected Units =
CALCULATE(
[Total Units],
TableName[Defect] = "Yes"
)
Drag the PO#, Total Units, Defected Units.
Hi 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
