I need to aggregate the dimension to a higher level. If all the subcategories in a category are successful then the final output of the category should be success else failure. I tried using LOD calculation but I am stuck. Can anyone help me with this?

Hi @Prassanth E​ , the lod expression below should help you knock this out

IF  { FIXED [Category] : MIN([State])} <> { FIXED [Category]: Max([State])} 
 
AND  { FIXED [Category],[Subcategory] : MIN([State])} = 'Success' or
 { FIXED [Category],[Subcategory] : MIN([State])}='Failure' THEN 'Failure'
 
ELSEIF  { FIXED [Category] : MIN([State])} = { FIXED [Category]: Max([State])} AND 
 
{ FIXED [Category],[Subcategory] : MIN([State])} = 'Success' THEN 'Success'
ELSE 'Failure'
END

workbook attached for ref. Let me know what you think about it.