Hi @Daniel_Schultz ,
You can try this method:
Create a summarized table first:
Table 2 =
"RF", 'Table'[Reason of Failure],
SUM ( 'Table'[Amount] ),
'Table'[Item_Name] = EARLIER ( 'Table'[Item_Name] )
&& 'Table'[Reason of Failure] = EARLIER ( 'Table'[Reason of Failure] )
Then new a measure in the first table:
Main Reason for Failures =
VAR _max =
MAX ( 'Table 2'[A] ),
ALLEXCEPT ( 'Table 2', 'Table 2'[Item_Name] )
CALCULATE ( MAX ( 'Table 2'[RF] ), FILTER ( 'Table 2', _max = [A] ) )
The result is:
Hope this helps you.
Here is my PBIX file.
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.