Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
datanau001
Helper III
Helper III

Dashboard chart with Target default value

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)Target Calculation.png

 

 

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

3 REPLIES 3
TeigeGao
Solution Sage
Solution Sage

Hi @datanau001 ,

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

Best Regards,

Teige

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

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

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.