Not show Sum or Average in Total (PIC INCLUDED)

[common763]

I have a matrix table with two rows.  Main one is C1, and the second is C2.  I then have C3 for values.  I want to display the sum only by C2 as in this situation it doesnt make sense to show C1 totals.  Is there a way to omit the numbers in the main category of C1?  I have displayed a pic.  Any help would be appreciated.   So omit the 15 under AAA, BBB, etc.  Just clicking row totals doesnt work because I cannot have the end-user click the plus sign and have it roll up to that AAA =  15 ever.  

[johnt75]

I think you can create a measure like

Sum at C2 level only =
IF ( ISINSCOPE ( 'Table'[C2] ), SUM ( 'Table'[C3] ) )

[common763]

If I do that it doesnt show anything for C1 and the matrix is blank.  I need it to display everything and not show the totals for C1.

[johnt75]

Can you share the PBIX ? You can post a link to Google Drive, OneDrive or similar.

[common763]

I think I found what I am looking for.  This kinda works.

ActiveS =
SWITCH(
    TRUE(),
    ISINSCOPE(ADC_by_W[VWards]), average(Wards[Active]),
    ISINSCOPE(ADC_by_W[DISPLAY_NAME]), "",
    ISINSCOPE(ADC_by_W[V]), "",
    "")

[v-menakakota]

Hi @common763 ,

 As you mentioned above that it worked for you can you confirm on that. If this is the solution that has worked for you please accept your reply as solution so as to help other community members who may face similar issue in the future

 
Thank you and Regards,
Menaka Kota.

[v-menakakota]

Hi @common763 ,

We really appreciate your efforts and for letting us know the update on the issue.

Please continue using fabric community forum for your further assistance.

If this is the solution that has worked for you please accept your reply as solution so as to help other community members who may face similar issue in the future

 
Thank you and Regards,
Menaka Kota.

[v-menakakota]

Hi @common763 ,

We really appreciate your efforts and for letting us know the update on the issue.

Please continue using fabric community forum for your further assistance.

If this is the solution that has worked for you please accept your reply as solution so as to help other community members who may face similar issue in the future

 
Thank you and Regards,
Menaka Kota.