topic Re: Not show Sum or Average in Total (PIC INCLUDED) in DAX Commands and Tips

Not show Sum or Average in Total (PIC INCLUDED)

common763 — Thu, 13 Mar 2025 13:02:21 GMT

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.

Re: Not show Sum or Average in Total (PIC INCLUDED)

johnt75 — Thu, 13 Mar 2025 13:54:34 GMT

I think you can create a measure like

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

Re: Not show Sum or Average in Total (PIC INCLUDED)

common763 — Thu, 13 Mar 2025 16:31:34 GMT

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.

Re: Not show Sum or Average in Total (PIC INCLUDED)

johnt75 — Thu, 13 Mar 2025 16:37:16 GMT

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

Re: Not show Sum or Average in Total (PIC INCLUDED)

common763 — Thu, 13 Mar 2025 17:48:40 GMT

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]), "",
"")

Re: Not show Sum or Average in Total (PIC INCLUDED)

v-menakakota — Fri, 09 May 2025 07:21:52 GMT

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.

Re: Not show Sum or Average in Total (PIC INCLUDED)

v-menakakota — Mon, 12 May 2025 11:22:10 GMT

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.

Re: Not show Sum or Average in Total (PIC INCLUDED)

v-menakakota — Fri, 16 May 2025 11:35:05 GMT

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.