Matrix table AVG not include zero

[Anonymous]

1. In Below matirx chart was to build & % was taken to show values but problem is by taking zeros the jan feb month of some fields the % reduced to 50%

2. But same Analyst or any other filed are getting 70% 80% for another months.

3. Our requirement is zero should mentioned but it should not impact on total & we need to get below excel menitoned % for table.

4. Zero shlould be kept like that only but in % we should not calculate that one.

[Ashish_Mathur]

Hi,

Share the download link of your PBI file with the measure already written.  Do you want to change the average in the row total or the column total?

[Anonymous]

Hi Ashish thanks for asking but its not a measure its just data field we have taken into chart now we need to show % without impact of Zero but Zero should be shown in Table. 

[Ashish_Mathur]

Hi,

As requested earlier, share the download link of the PBI file.