I have added Net result in my report. What I would like to highlight was Cost Centre with the Net Result worse than group average not the group total.
In my case, Cost Centre 1002,1008,1004,1005, and 1003 should be highlighted.
But with the total, it is only highlighted for 1003.
Can you please guide me the correct DAX.
Regards.ConditionalFormattingBasedOnSubtotal.xlsx (49.4 KB) Q_AverageNetResultbyGroupForConditionalFormating.pbix (50.3 KB)