Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |