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()))

     

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
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()))