Each row in your table is a transaction, but your table also includes things like shipping fees. While there is a shipping feel listed for each transaction, the number repeats for every row because it actually only makes sense for the order as a whole. Summing up that column would double, triple, and quadruple count the fee resulting in wildly incorrect answers. In this video I’m going to not only walk you through the surprisingly simple way this problem is solved, I’ll also walk you through how to understand the solution and even use DAX to visualize it on the page.
The SkyPoint AI Platform
Our AI Platform for industries helps unify your data, chat with your data, and optimize productivity.
Drive enterprise AI and digital transformation with our Professional Services.
Data & AI Services
Data & AI Expertise
Data and AI Solutions
SkyPoint AI delivers an industry-specific platform infrastructure enabling quick access to quality data, intelligence, analytics, and automation.
AI Use Cases
AI for Industries
Data and AI Resources
Trainings, strategies, techniques, and experiences from our data solutions experts and customers.
Training and Events
Get in Touch
We bring people and data together by making information more accessible, reliable, valuable, and tangible.