Include in total calculation but not team breakdown

[Anonymous]

Hi,

On our monthly reporting we include a Gender Pay Gap breakdown. I want to include our Exec members in the overall company calculation which is the 'Total' field but not in the divisional breakdowns. As you can see in the image below teh first row (100%) is the Exec member singled out with no division listed. If I hide the division using the filters it excludes them from the overall total %. Is there a way I can include in total but not have listed in visualisation?

[v-yulgu-msft]

Hi @Anonymous,

Please illustrate your scenario with some dummy data to make the requirement more clear. Also, please show us the desired output.

How to Get Your Question Answered Quickly

Best regards,

Yuliana Gu

[Anonymous]

@v-yulgu-msft thanks.

Below is the visualisation - I am trying to remove/hide blank 'Division' but include that individual in the total if it makes sense. 

Someone suggested using HASONEVALUE dax but it doesn't seem to be working. The equation I have to pull through test Measure is as below:

Test Measure = IF (
HASONEVALUE('Aug Rem Report'[Division Code]), CALCULATE('Aug Rem Report'[August GPG]))