Dashboard chart with Target default value

[datanau001]

Dear all,

I’d like to request your support with the following.

I'm working with a report where I created one calculated measure with some targets for my groups ( see in below image the continuous line in red)

E.g:

if severity of issue handled is “Critical” and the group is "X" then target will be like below:

KPI =
IF('Base Data'[DWH_SEVERITY]="1-Critical";
IF('Base Data'[DWH_SR_GROUP]="Z" ||
'Base Data'[DWH_SR_GROUP]="Z_1" ||
'Base Data'[DWH_SR_GROUP]="Z_2" ||
'Base Data'[DWH_SR_GROUP]="Z_3"
;"18");

IF('Base Data'[DWH_SEVERITY]="2-High";
IF('Base Data'[DWH_SR_GROUP]="Z" ||
'Base Data'[DWH_SR_GROUP]="Z_1" ||
'Base Data'[DWH_SR_GROUP]="Z_2" ||
'Base Data'[DWH_SR_GROUP]="Z_3" ||
;"25");

IF('Base Data'[DWH_SEVERITY]="3-Medium";
IF('Base Data'[DWH_SR_GROUP]="Z" ||
'Base Data'[DWH_SR_GROUP]="Z_1" ||
'Base Data'[DWH_SR_GROUP]="Z_2" ||
'Base Data'[DWH_SR_GROUP]="Z_3" ||
;"45");

IF('Base Data'[DWH_SEVERITY]="4-Low";
IF('Base Data'[DWH_SR_GROUP]="Z" ||
'Base Data'[DWH_SR_GROUP]="Z_1" ||
'Base Data'[DWH_SR_GROUP]="Z_2" ||
'Base Data'[DWH_SR_GROUP]="Z_3" ||
;"60");"0"))))) +

IF('Base Data'[DWH_SEVERITY]="1-Critical";
IF('Base Data'[DWH_SR_GROUP]="Y" ||
'Base Data'[DWH_SR_GROUP]="Y_1" ||
'Base Data'[DWH_SR_GROUP]="Y_2" ||
'Base Data'[DWH_SR_GROUP]="Y_3"
;"18");

IF('Base Data'[DWH_SEVERITY]="2-High";
IF('Base Data'[DWH_SR_GROUP]="Y" ||
'Base Data'[DWH_SR_GROUP]="Y_1" ||
'Base Data'[DWH_SR_GROUP]="Y_2" ||
'Base Data'[DWH_SR_GROUP]="Y_3" ||
;"25");

IF('Base Data'[DWH_SEVERITY]="3-Medium";
IF('Base Data'[DWH_SR_GROUP]="Y" ||
'Base Data'[DWH_SR_GROUP]="Y_1" ||
'Base Data'[DWH_SR_GROUP]="Y_2" ||
'Base Data'[DWH_SR_GROUP]="Y_3" ||
;"45");

IF('Base Data'[DWH_SEVERITY]="4-Low";
IF('Base Data'[DWH_SR_GROUP]="Y" ||
'Base Data'[DWH_SR_GROUP]="Y_1" ||
'Base Data'[DWH_SR_GROUP]="Y_2" ||
'Base Data'[DWH_SR_GROUP]="Y_3" ||
;"60");"0"))))) +

IF('Base Data'[DWH_SEVERITY]="1-Critical";
IF('Base Data'[DWH_SR_GROUP]="X" ||
'Base Data'[DWH_SR_GROUP]="Y_1" ||
'Base Data'[DWH_SR_GROUP]="Y_2" ||
'Base Data'[DWH_SR_GROUP]="Y_3"
;"6");

IF('Base Data'[DWH_SEVERITY]="2-High";
IF('Base Data'[DWH_SR_GROUP]="X" ||
'Base Data'[DWH_SR_GROUP]="X_1" ||
'Base Data'[DWH_SR_GROUP]="X_2" ||
'Base Data'[DWH_SR_GROUP]="X_3" ||
;"8");

IF('Base Data'[DWH_SEVERITY]="3-Medium";
IF('Base Data'[DWH_SR_GROUP]="X" ||
'Base Data'[DWH_SR_GROUP]="X_1" ||
'Base Data'[DWH_SR_GROUP]="X_2" ||
'Base Data'[DWH_SR_GROUP]="X_3" ||
;"12");

IF('Base Data'[DWH_SEVERITY]="4-Low";
IF('Base Data'[DWH_SR_GROUP]="X" ||
'Base Data'[DWH_SR_GROUP]="X_1" ||
'Base Data'[DWH_SR_GROUP]="X_2" ||
'Base Data'[DWH_SR_GROUP]="X_3"
;"20");"0")))))

For each set of groups (X,Y,Z) I use a conditional column (slicer) to filter the page. But there are some "Severity" targets that are not related to the groups and should not be filtered.

E.g: if any of the slicer options is selected then the targets values should be:

If Severity is “1-Critical”  then 21

If severity is "2-High" then 24

If severity is “3-Medium” then 47

If severity is “4-Low” then 42

And here, I’m not sure how to add these conditions in the same formula above. I tried with “OR” function at the end, but it is not working.

Due to some data privacy, I’m not able to share the complete report but in the link below, you’ll find a sample of the formula I’m using.

Please, let me know in case you need some more details from my end.

Thank you
Marcelo

[TeigeGao]

Hi @datanau001 ,

Could you please share your resource data file via Onedrive? I can't access your file.

Best Regards,

Teige

[datanau001]

Hello Taige,

Thank for replying me.

Due to some to some privacy roles at my end, I was not able to share the data. however I edited the post where I added some more information.

Regards

Marcelo

[datanau001]

Hello Taige,

Thank for replying me.

Due to some to some privacy roles at my end, I was not able to share the data. however I edited the post where I added some more information.

Regards

Marcelo