Matrix Table Total Row not calculating right totals

[ppgandhi11]

Hi,

Because some of the rows are not applicable based on the filter value, it does not show up in the matrix table. However, the total it displays at the bottom includes those missing data points. How do I get just the total of the lines displayed?

[v-chuncz-msft · Accepted solution]

@ppgandhi11,

You may use SUMX Function to add an additonal measure.

https://community.powerbi.com/t5/Desktop/Sum-of-values-in-a-measure-with-divide-measure/m-p/296768#M...

[ppgandhi11]

for example, the table is as below.

NPI   # of patients seen (measure)  Service

A         20                                              1.1

B         30                                              1.1

C         10                                              1.2

D        40                                               1.2

Service is a filter. When I select 1.1 service, the matrix shows below:

NPI    # of patients seen

A         20

B         30

-----------------

Total    100    <-- this is incorrect. it displayed 100 because all 4 NPI totalled 100. However, the right total should have been 50. How woudl i get 50 there? (20+30)