DAX to conditionally exclude rows from table grand total

[00Jess00]

Hello,

Is anybody able to assist with the below?

I have a measure that does not calculate the percentage if TWOX and GT are the same number (showing N/A instead).

But this is not working for the grand total at the bottom - so the % for site group A is now 93% rather than 90%. Ideally I would like the keep the grand total for TWOX and GT with (280 and 300) with the correct % (90%)

Site_Group           Site                   TWOX                    GT         %

A                           1                        94                         100              94%

A                           2                        86                         100              86%

A                           3                       100                        100              N/A

Total                                              280                        300               93%

Thanks,

[RSC]

Hi @00Jess00,
can you please tell me what measure you wrote?
And try TRUNC function For TWOX.
I look forward to you reply
Thanks!

[00Jess00]

Sure, it is:

% = IF(TWOX=GT, "N/A", (TWOX/GT))

Thank you!