Forum Discussion

SUMESHKUMAR22's avatar
SUMESHKUMAR22
Icon for Helper IV rankHelper IV
2 years ago
Solved

Matrix Conditional formatting on column subtotals

Hi community,

My requirement is to conditional format the below highlighted only Total value of the columns Total. (It's giving the sum vertically)
Pbix attached hereby.


Fowmy , FYI

Thanks in advance

General Comment
Need Help
Show and Tell
Tips and Tricks
  • Fowmy's avatar
    Fowmy
    2 years ago

    SUMESHKUMAR22 

    Create this measure:

    CF = INT(NOT ISINSCOPE( data[TIMESHEET MONTH YEAR] ) && NOT ISINSCOPE( data[Resource name] ) && ISINSCOPE( data[Phase]))


    Select FX under Cell Elements


    Assign the Measure and the values:



    Result:

     

     



     

2 Replies

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    2 years ago

    SUMESHKUMAR22 

    Create this measure:

    CF = INT(NOT ISINSCOPE( data[TIMESHEET MONTH YEAR] ) && NOT ISINSCOPE( data[Resource name] ) && ISINSCOPE( data[Phase]))


    Select FX under Cell Elements


    Assign the Measure and the values:



    Result: