Remove Average data coming matrix when grouping is applied to it

Hi Pratha ,

 

To remove the average values that appear when grouping is applied in a Power BI matrix, you can modify your DAX measures to return a blank value when the matrix is at the group (subtotal) level. The issue occurs because Power BI automatically calculates an average or other aggregation for subtotal rows, even if you don’t want it to. To prevent this, you can use the ISINSCOPE function in your measure to check if the specific column used for grouping is currently in scope. If it is, the measure returns the original value; if not, it returns blank. This ensures that only detail rows show values, and subtotal rows remain empty.

Here's the syntax:

YourMeasure :=
IF(
    ISINSCOPE('YourTable'[FunctionColumn]),
    [YourOriginalMeasure],
    BLANK()
)

Replace 'YourTable'[FunctionColumn] with the actual column used in your "Summed Functions" grouping. Also, [YourOriginalMeasure] should be the expression or measure you originally used to calculate values for each quarter or period. You’ll need to apply this logic to each relevant measure (Q1, Q2, Q3, Q4, H1, H2, FY) to suppress the subtotal values across the entire matrix.

 

Best regards,

Hi Pratha, 
Thank you for reaching out to the Microsoft fabric community forum. Thank you DataNinja777  for your input on this issue.
 After thoroughly reviewing the details you provided, I was able to reproduce the scenario, I have used it as sample data on my end and successfully implemented it.   

Dax Measure:  

% Display Measure = 
IF (
    ISINSCOPE(PerformanceData[SubFunction]),
    BLANK(),
    AVERAGE(PerformanceData[Percentage])
)

Output: 

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly. 
 
Thank you.