The oft-frustrating unexpected column totals (weighted ratio)

DAX DAX Calculations
1

Hello experts,

Unfortunately, I fundamentally don’t how a weighted ratio measure can work as expected as a sum total. I’ve shared all of the pertinent details - and DAX logic - in the attached, The examples I find on your sites and others are fine building blocks, but I can’t connect the dots when multiple base tables, source columns, and measures are involved.

A Frustrating Cannot-Sum-the-Column-Properly Problem.docx (68.9 KB)

Your guidance is appreciated.

Thank you,
Kevin

2

Hi @kkieger,

While waiting for the community to review and respond to your issue, take advantage of Data Mentor . It offers a wealth of tools and resources that could provide immediate solutions and enhance your report-building efficiency.

Suggested link: https://mentor.enterprisedna.co/explain-simply

image
image1555×906 106 KB

Cheers,

Enterprise DNA Support Team