Summarize Audits by PO #

[shaylacrowe]

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! 

[rajendraongole1]

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 

[Angith_Nair]

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.

[Kedar_Pande · Accepted solution]

@shaylacrowe 

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

[shaylacrowe]

This worked! Thank you SO much!!!