So I have a matrix visual that I’m trying to have display different values for each line.
Here is a slimmed down example.
Machine Calculation 1 *Sum of all defects* Style *Sum of defects for Machine 1* Defect description *Sum of defects as a part of Machine 1*
I’ve tried adapting an example that was used in “Getting Totals Correct When Using Advanced Logic - Power BI DAX” but since it’s a subtotal and not a grand total, the HASONEFILTER() wouldn’t be applicable. I’ve figured it out for when you are applying a measure to a heirarchy change but the application I need it for is when the matrix is expanded.
Defect Percentage Calculation:
Here is a link to an example of what I have currently in BI.
I’m not sure whether or not it’s even possible but basically I’m looking to have a different measure rather than the subtotal. I’m looking to get the machines to
show the defect total as:
(defects of machine) / (total defects);
where as the style and defect description needs to be:
(defects of style or defect description) / (defect total for machine)
instead of a subtotal if that makes sense? I’ve tried everything but I’m not sure if matrices are built that way?