Matrix - How to avoid Total and Subtotal aggregation for a field

[manojsv16]

Hello Team,

I am working on a report that has a requirement that i want to create a matrix with following information.

Rows

1. State

2. Region

3. City     

Values

1. Customers

2. Billed

3. % Billed 

% Billing is measure calcualted based on the formulat ( # Billed/ #customers ) in percentage. I would like to have the total and subtotals for Customers, Billed value field in matrix. But for % Billed, I don't want to see the total and subtotal aggregation based on Rows.

Please help me in how to avoid the total and subtotal only for % Billed measures. I know we can either have total and subtotal for all values or avoid for all values. but ,i dont know how to avoid for a value fields.

I would appreciate any suggestions on resolving this issue.

Thank you!!

[v-yulgu-msft · Accepted solution]

Hi @manojsv16,

Please refer to below measure:

Bill% = IF(ISINSCOPE('Test Data'[City]),SUM('Test Data'[Bill])/SUM('Test Data'[Customer]))

Best regards,

Yuliana Gu