Measure Considering only a subset of filters

[Crysis85]

I have a set of Offices in my organization, divided in Groups, each Office keep track of its Operations.

I have to create a KPI that when I go in drilldown on a single Office it confronts its Operations with a Measure of Count(Operations)/Count(Offices) but only relative to the selected Office's Group, not all the Offices.

I tried creating a measure of this division but when i select the sigle Office the measure too is filtered to that, and if I make it ignore selections it considers all the Offices (all the Groups).

How can I make this measure ignore all the selection filters except the one regarding the selected Office's Group?

Thanks for the help.

[v-yulgu-msft · Accepted solution]

Hi @Crysis85,

Please try this measure:

Divid measure =
COUNT ( Offices[Operations] )
    / CALCULATE ( COUNT ( Offices[Office] ), ALL ( Offices[Office] ) )

Regards,

Yuliana Gu