Altering context of measure

[po]

Hi,

have below as can see from circled area on right shows 100% in green as when the results are aggregated to region level all are green.

However, the consituent rows have som reds and yellows in them - is it possible for the measure to evaluate the results at row level and consider these in which case if operated at that level would see 4 fails (i. non green) so wouldn't be 100% - ideally want the reds/yellows to be included as indicated by the arrow below.

definition of measure

No. of Weekly KPIs met = IF (

HASONEVALUE ( Targets[KPI Name] ),

[KPI Flag],

COUNTROWS (

FILTER ( VALUES ( Targets[KPI Name] ), CALCULATE ( SUMX ( VALUES ( Targets[KPI Name] ), [KPI Flag] ) ) >= 0 )

)

)

kpi flag definition below

KPI Flag =
SWITCH(
TRUE(),

MAX(Targets[KPI Unit]) = "£",
SWITCH(TRUE(),

[KPI Currency Value] > [KPI Currency Target Max],-1,
[KPI Currency Value] <= [KPI Currency Target Max] &&
[KPI Currency Value] > [KPI Currency Target Min],0,1),

MAX(Targets[KPI Unit]) = "%" ,
SWITCH(TRUE(),

[KPI Percentage Value] < [KPI Percentage Target Max],-1,
[KPI Percentage Value] >= [KPI Percentage Target Max] &&
[KPI Percentage Value] < [KPI Percentage Target Min],0,1),

MAX(Targets[KPI Unit]) = "#",
SWITCH(TRUE(),

[KPI Score Value] > [KPI Score Target Max],-1,
[KPI Score Value] <= [KPI Score Target Max] &&
[KPI Score Value] > [KPI Score Target Min],0,1),

-2
)

[v-cherch-msft]

Hi @po 

It seems you may need to use conditional formatting .For further,you may have a look at this post.If it is not your case,please share some data sample and expected output.

How to Get Your Question Answered Quickly

Regards,

[po]

Hi,

Thanks for reply - have conditional formatting.

can't upload this particular data unfortunately.

By default the measure being evaluated at the region context i.e gets the sums at regional level and because at regional level all passed i.e.  green shows 100%.

Wondered if way to instead say results at constituent level (i.e. city) e.g if sum (<measure>) at city can see some cities in the region failed some measures thus would be < 100%

Thanks

[v-cherch-msft]

Hi @po 

Based on my test,i cannot reproduce the same issue.Could you provide some simplified assumed data to reproduce your scenario?

Regards,