Urgent support - Matrix adjust row subtotal and total

Hi xiumi_hou 

What you're trying to achieve is partially possible:

• conditional formatting cannot be applied to row and column headers. You can apply formatting to row and column headers but they will not be conditional - they will be applied to all.
• you can make the subtotal line disappear  if set to top. You screenshot shows they're at the bottom

Here's a sample formula for background conditional formattting to be applied as a field value to both values and totals. You will need to specify in the measure the first subtotal column value (APAC in my example).

Total Color = 
IF (
    NOT ( HASONEVALUE ( Geo[Geo] ) )
        || (
            NOT ( HASONEVALUE ( Category[Category] ) )
                && SELECTEDVALUE ( Data[Geo] ) = "APAC"
        ),
    "orange"
)

The formula below will selectively hide the subtotal. You will need to specify the second subtotal value which in my example is EMEA.  This will check whether the category value is EMEA and the lower level hierarchy is not in scope as the one that is inscope at the subtotal level is EMEA. If the condition is SELECTEDVALUE ( Data[Geo] ) = "EMEA", it will return blank for all rows which geo is EMEA.

Total_Revenue = 
IF (
    SELECTEDVALUE ( Data[Geo] ) = "EMEA"
        && NOT ( ISINSCOPE ( Category[Category] ) ),
    BLANK (),
    [Total Revenue]
)

Please see attached sample pbix.