Calculate Max and Min value of subcategory within category on unpivot data with slicer

[Anonymous]

Hi, 
I need categorywise Max and Min value of aggregated average on unpivot data.
I attached data and needed result screenshot also.
In data, actually I have 3 concepts which have 4 levels each. sq variable with text datawill be in slicer . Utility score needs aggregated as average and categorywise max-min in next column as per screenshot.
KIndly help to fix it out, I am not able to use max value on aggregated  variable in matrix. 

[Anonymous]

Hi @Anonymous 

Not very clear about your table structure and what role sq variables play in your data, if you can provide your example pbix file then I would be happy to help you.Please remove any sensitive data in advance.

Best regards

Jayleny

[Anonymous]

Hi, That variable will be used in slicer for filter. Anyway, it has been resoved.
Now my next query is, how to display blank like 4th column (Diff. of max & min) of result screenshot. For example, for 1st category, max=0.024 & min=-0.028 then diff=0.052 will be repetitive in each row of category. I need only one time in each category just like screenshot.