The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
I am working on two existing matrixes - Matrix 1 and Matrix 2 - both of which come from the very same SQL Server Table source.
Matrix 1 - Total Population.
Matrix 2 - The subset within the Total Population which fulfils a specified criteria (which I am working with).
Matrix 3 is what I am trying to create i.e Division of each Matrix 2 value over their corresponding value in Matrix 1. The Percentage values in Matrix 3 below are only HARD-CODED and is what I am trying to calculate .
Please advise on the best way to create Matrix 3.