Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

problem in removing Subtotal

I have used the below formula for removing the Subtotals. But for Company with single row the subtotal is not removing. Similarly for the CAP_TYPE column if 2 rows has large then the TOTAL is ...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Anonymous ,

     

    Please create the measures as below to work on it.

    A = IF([M_CAP TYPE] = "Large",1,0)

    A1 = SUMX('Merge2-Used for Earnings Monitor Tbale Format',[A])
    A2 = IF(ISINSCOPE('Merge2-Used for Earnings Monitor Tbale Format'[CONAME]),[M_CAP TYPE],IF([A1]>=2,"Large",BLANK()))

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous  Please select matrix click on format pane and turn off the row subtotal option

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous  i need Subtotal for limited column. so that is why i am removing subtotal for the columns which i needed.