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

     

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
6 years ago

 

Anonymous 

use "table" instead of "Matrix" (from the visualization pane)

if the data is loaded like this, then use power query and remove those rows