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 ,

 

If and ISINCOPE function should help you in your scenario. Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.