I have a super intricate one here, so please have patience with me. Any help is very much appreciated.
All proprietary information has been changed.
3 Tables plus a Calendar Table
I have a measure "True Overall Score" being sorted by a Calendar table and Company name column in a matrix. Company name as the Rows, Month as the Columns, and the measure I created as the values. Individually the measure works perfectly with all the months and companies, it gives a percentage based off of two other calculated measures listed below.
My calendar table it connected to the 3 different tables "RECEIPTSTABLE", "STRIKESTABLE", and "DEMERITTABLE"; then its sorted by month.
"STRIKESTABLE" and "DEMERITTABLE" are tables that need to negatively impact the company score, where as "RECEIPTSTABLE" just has number of received shipments and if they were late or on time. Late also negatively impacts the score.
I have over 50 companies listed, I use slicers to select 1, multiple, or all for the companies or months.
My slicers are synced to work on all 3 tables for matching company names.
My measures look like this
True Our Qty = (SUM(RECEIPTSTABLE[OurQty]))
On Time = (SUMX(filter(RECEIPTSTABLE, RECEIPTSTABLE[Status by Datediff] = "On Time"), [OurQty]) - SUM(DEMERITTABLE[Quantity])+0) / RECEIPTSTABLE[True Our Qty]
