⚠️ Are your Power BI reports showing WRONG totals because of DUPLICATE records?
In this video, I'll show you exactly how to fix duplicate data using SUMX + SUMMARIZE in DAX — a powerful combination that every Power BI user MUST know!
✅ What you'll learn:
- Why duplicate Requisition IDs cause wrong Net Weight totals
- How SUMMARIZE removes duplicate rows in DAX
- How SUMX iterates and sums correctly over unique records
- Real use case with actual data — step by step!
📌 DAX Formula Used:
SUMX(
SUMMARIZE(
TableName,
[Requisition ID],
[Total Weight]
),
[Net Weight]
)
⏱️ Timestamps:
00:00 - Problem: Duplicate Records in Power BI
01:30 - What is SUMMARIZE in DAX?
03:00 - What is SUMX in DAX?
04:30 - Combining SUMX + SUMMARIZE
06:00 - Live Demo & Result
🔔 If this helped you, LIKE & SUBSCRIBE for more Power BI & DAX tips!
#PowerBI #DAX #SUMX #SUMMARIZE #PowerBITutorial #DAXFormula #DuplicateRecords #DataAnalysis #BusinessIntelligence #PowerBITips
Download
0 formats
No download links available.
Remove Duplicate Records Using SUMX + SUMMARIZE in Power BI 🔥 | NatokHD