Bad result after calculated measure SLA

Hello,
Im facing a problem with a report with Total percentage of complete SLA process.

My Measures:

CASE
WHEN ([Issue Type].CurrentMember.name = ‘Corrective’ OR [Issue Type].CurrentMember.name = ‘Corrective Sub-task’) AND [Front].CurrentMember.name = ‘Objetivo’ THEN 0.90
WHEN [Issue Type].CurrentMember.name = ‘Corrective’ OR [Issue Type].CurrentMember.name = ‘Corrective Sub-task’ THEN
CASE WHEN [Measures].[Issues closed] > 0 AND [Measures].[OB – Corrective – Time to Test - Breached] > 0 THEN
CoalesceEmpty([Measures].[Issues closed] - [Measures].[OB – Corrective – Time to Test - Breached] + [Measures].[OB - Corrective - Time to Test - Allegation], 0) /
[Measures].[Issues closed]
WHEN [Measures].[Issues closed] > 0 AND IsEmpty([Measures].[OB – Corrective – Time to Test - Breached]) THEN 1
END
END

The problem is it takes a total of issues but sometimes the calculation shows for example 93,79% complete and when drill to see all the issues all of them are completed.

I dont know why the total calculation is not 100%.

Thanks in advance for any help.

After some analyse I figure out that in the detailed issues view all display 100%, but that is wrong, in some of them the value need to be 0, but I dont know how to solve this situation.

Export definition:

{
“cube_name”: “Issues”,
“cube_reports”: [ {
“name”: “SLA Global Front”,
“folder_name”: “SLA”,
“result_view”: “table”,
“definition”: {“columns”:{“dimensions”:[{“name”:“Issue Type”,“selected_set”:["[Issue Type].[Corrective]","[Issue Type].[Evolutive]","[Issue Type].[Prearranged]","[Issue Type].[Master Data]","[Issue Type].[User Management]","[Issue Type].[Support]"],“members”:[],“bookmarked_members”:[]},{“name”:“Measures”,“selected_set”:["[Measures].[OB - Corrective - Time to Test]","[Measures].[OB - Corrective - Time to Transport]","[Measures].[OB - Evolutive - Time to Transport]","[Measures].[OB - Prearranged - Time to Estimation]","[Measures].[OB - Prearranged - Time to Implementation]","[Measures].[OB - Prearranged - Time to Transport]","[Measures].[OB - Master Data - Time to Implementation]","[Measures].[OB - User Management - Time to Implementation]","[Measures].[OB - Support - Time to Estimation]","[Measures].[OB - Support - Time to Implementation]","[Measures].[OB - Evolutive - Time to Estimation]","[Measures].[OB - Evolutive - Time to Implementation]"],“members”:[]}]},“rows”:{“dimensions”:[{“name”:“Front”,“selected_set”:["[Front].[All Fronts]"],“members”:[{“depth”:0,“name”:“All Fronts”,“full_name”:"[Front].[All Fronts]",“drillable”:true,“type”:“all”,“expanded”:true,“drilled_into”:false}],“bookmarked_members”:[]},{“name”:“Issue”,“selected_set”:["[Issue].[Project].Members"],“members”:[],“bookmarked_members”:[]}],“nonempty_crossjoin”:true},“pages”:{“dimensions”:[{“name”:“Time”,“selected_set”:["[Time].[Previous-month]"],“members”:[{“depth”:0,“name”:“Previous-month”,“full_name”:"[Time].[Previous-month]",“calculated”:true}],“bookmarked_members”:[],“current_page_members”:["[Time].[Previous-month]"]},{“name”:“Status”,“selected_set”:["[Status].[Closed]"],“members”:[{“depth”:1,“name”:“Closed”,“full_name”:"[Status].[Closed]"}],“bookmarked_members”:[],“current_page_members”:["[Status].[Closed]"]},{“name”:“Assigned Group”,“selected_set”:["[Assigned Group].[All Assigned Groups]","[Assigned Group].[NO-SAPMNGT-No-Det]"],“members”:[{“depth”:0,“name”:“NO-SAPMNGT-No-Det”,“full_name”:"[Assigned Group].[NO-SAPMNGT-No-Det]",“calculated”:true}],“bookmarked_members”:[],“current_page_members”:["[Assigned Group].[NO-SAPMNGT-No-Det]"]},{“name”:“BKLOG Local Module”,“selected_set”:["[BKLOG Local Module].[All BKLOG Local Modules]"],“members”:[{“depth”:0,“name”:“All BKLOG Local Modules”,“full_name”:"[BKLOG Local Module].[All BKLOG Local Modules]",“drillable”:true,“type”:“all”,“expanded”:true,“drilled_into”:false},{“depth”:1,“name”:“Back Log”,“full_name”:"[BKLOG Local Module].[Back Log]",“key”:“CMDB-3723”,“parent_full_name”:"[BKLOG Local Module].[All BKLOG Local Modules]"}],“bookmarked_members”:[],“current_page_members”:["[BKLOG Local Module].[Back Log]"]},{“name”:“Priority”,“selected_set”:["[Priority].DefaultMember"],“members”:[{“depth”:0,“name”:“All Priorities”,“full_name”:"[Priority].[All Priorities]",“drillable”:true,“type”:“all”}],“bookmarked_members”:[],“current_page_members”:["[Priority].[All Priorities]"]},{“name”:“Country”,“selected_set”:["[Country].[All Countries]"],“members”:[{“depth”:0,“name”:“All Countries”,“full_name”:"[Country].[All Countries]",“drillable”:true,“type”:“all”}],“bookmarked_members”:[],“current_page_members”:["[Country].[All Countries]"]},{“name”:“Issue Type”,“duplicate”:true,“selected_set”:["[Issue Type].[Corrective]","[Issue Type].[Evolutive]","[Issue Type].[Prearranged]","[Issue Type].[Master Data]","[Issue Type].[User Management]","[Issue Type].[Support]"],“members”:[{“depth”:1,“name”:“Corrective”,“full_name”:"[Issue Type].[Corrective]"},{“depth”:1,“name”:“Evolutive”,“full_name”:"[Issue Type].[Evolutive]"},{“depth”:1,“name”:“Prearranged”,“full_name”:"[Issue Type].[Prearranged]"},{“depth”:1,“name”:“Master Data”,“full_name”:"[Issue Type].[Master Data]"},{“depth”:1,“name”:“User Management”,“full_name”:"[Issue Type].[User Management]"},{“depth”:1,“name”:“Support”,“full_name”:"[Issue Type].[Support]"}],“bookmarked_members”:[],“current_page_members”:["[Issue Type].[Corrective]","[Issue Type].[Evolutive]","[Issue Type].[Prearranged]","[Issue Type].[Master Data]","[Issue Type].[User Management]","[Issue Type].[Support]"]},{“name”:“Front”,“duplicate”:true,“selected_set”:["[Front].[FI]","[Front].[All Fronts]"],“members”:[{“depth”:0,“name”:“All Fronts”,“full_name”:"[Front].[All Fronts]",“drillable”:true,“type”:“all”}],“bookmarked_members”:[],“current_page_members”:["[Front].[All Fronts]"]}]},“options”:{“nonempty”:true},“view”:{“current”:“table”,“maximized”:false,“table”:{“cell_formatting”:{"[Issue Type].[Support]":[{“background_color”:"#AA4643",“max”:“0.8999”,“bold”:true}],"[Issue Type].[Evolutive]":[{“max”:“0.89999”,“background_color”:"#AA4643"}],"[Issue Type].[Corrective]":[{“max”:“0.89999”,“background_color”:"#AA4643"}],"[Issue Type].[Prearranged]":[{“max”:“0.89999”,“background_color”:"#AA4643"}],"[Issue Type].[Master Data]":[{“max”:“0.94999”,“background_color”:"#AA4643"}],"[Issue Type].[User Management]":[{“max”:“0.94999”,“background_color”:"#AA4643"}]}}},“embed_options”:{“show_header”:true,“show_border”:true,“enable_export”:false,“disable_actions”:false,“embed_token”:“f7zfwmvr57vgm2snbhzbf79yaz8hr8qi4ochauvw9lx7zbr38tma3p6tyl3x”}}
} ],
“calculated_members”: [{“name”:“NO-SAPMNGT-No-Det”,“dimension”:“Assigned Group”,“formula”:"[Assigned Group].DefaultMember - [Assigned Group].[SAP MANAGEMENT]",“format_string”:""},{“name”:“OB - Corrective - Time to Test”,“dimension”:“Measures”,“formula”:“CASE\nWHEN ([Issue Type].CurrentMember.name = ‘Corrective’ OR [Issue Type].CurrentMember.name = ‘Corrective Sub-task’) AND [Front].CurrentMember.name = ‘Objetivo’ THEN 0.90\nWHEN [Issue Type].CurrentMember.name = ‘Corrective’ OR [Issue Type].CurrentMember.name = ‘Corrective Sub-task’ THEN\n CASE WHEN [Measures].[Issues closed] > 0 AND [Measures].[OB \u2013 Corrective \u2013 Time to Test - Breached] > 0 THEN\n CoalesceEmpty([Measures].[Issues closed] - [Measures].[OB \u2013 Corrective \u2013 Time to Test - Breached] + [Measures].[OB - Corrective - Time to Test - Allegation], 0) /\n [Measures].[Issues closed]\n WHEN [Measures].[Issues closed] > 0 AND IsEmpty([Measures].[OB \u2013 Corrective \u2013 Time to Test - Breached]) THEN 1\n END\nEND”,“format_string”:"#0.00%"},{“name”:“OB - Corrective - Time to Transport”,“dimension”:“Measures”,“formula”:“CASE\nWHEN ([Issue Type].CurrentMember.name = ‘Corrective’ OR [Issue Type].CurrentMember.name = ‘Corrective Sub-task’) AND [Front].CurrentMember.name = ‘Objetivo’ THEN 0.90\nWHEN [Issue Type].CurrentMember.name = ‘Corrective’ OR [Issue Type].CurrentMember.name = ‘Corrective Sub-task’ THEN\n CASE WHEN [Measures].[Issues closed] > 0 AND [Measures].[OB \u2013 Corrective \u2013 Time to Transport - Breached] > 0 THEN\n CoalesceEmpty([Measures].[Issues closed] - [Measures].[OB \u2013 Corrective \u2013 Time to Transport - Breached] + [Measures].[OB - Corrective - Time to Transport - Allegation], 0) /\n [Measures].[Issues closed]\n WHEN [Measures].[Issues closed] > 0 AND IsEmpty([Measures].[OB \u2013 Corrective \u2013 Time to Transport - Breached]) THEN 1\n END\nEND”,“format_string”:"#0.00%"},{“name”:“OB - Support - Time to Estimation”,“dimension”:“Measures”,“formula”:“CASE\nWHEN ([Issue Type].CurrentMember.name = ‘Support’ OR [Issue Type].CurrentMember.name = ‘Support Sub-task’) AND [Front].CurrentMember.name = ‘Objetivo’ THEN 0.90\nWHEN [Issue Type].CurrentMember.name = ‘Support’ OR [Issue Type].CurrentMember.name = ‘Support Sub-task’ THEN\n CASE WHEN [Measures].[Issues closed] > 0 AND [Measures].[OB \u2013 Support \u2013 Time to Estimation - Breached] > 0 THEN\n CoalesceEmpty([Measures].[Issues closed] - [Measures].[OB \u2013 Support \u2013 Time to Estimation - Breached] + [Measures].[OB - Support - Time to Estimation - Allegation], 0) /\n [Measures].[Issues closed]\n WHEN [Measures].[Issues closed] > 0 AND IsEmpty([Measures].[OB \u2013 Support \u2013 Time to Estimation - Breached]) THEN 1\n END\nEND”,“format_string”:"#0.00%"},{“name”:“OB - Support - Time to Implementation”,“dimension”:“Measures”,“formula”:“CASE\nWHEN ([Issue Type].CurrentMember.name = ‘Support’ OR [Issue Type].CurrentMember.name = ‘Support Sub-task’) AND [Front].CurrentMember.name = ‘Objetivo’ THEN 0.90\nWHEN [Issue Type].CurrentMember.name = ‘Support’ OR [Issue Type].CurrentMember.name = ‘Support Sub-task’ THEN\n CASE WHEN [Measures].[Issues closed] > 0 AND [Measures].[OB \u2013 Support \u2013 Time to Implementation - Breached] > 0 THEN\n CoalesceEmpty([Measures].[Issues closed] - [Measures].[OB \u2013 Support \u2013 Time to Implementation - Breached] + [Measures].[OB - Support - Time to Implementation - Allegation], 0) /\n [Measures].[Issues closed]\n WHEN [Measures].[Issues closed] > 0 AND IsEmpty([Measures].[OB \u2013 Support \u2013 Time to Implementation - Breached]) THEN 1\n END\nEND”,“format_string”:"#0.00%"},{“name”:“OB - Prearranged - Time to Estimation”,“dimension”:“Measures”,“formula”:“CASE\nWHEN ([Issue Type].CurrentMember.name = ‘Prearranged’ OR [Issue Type].CurrentMember.name = ‘Prearranged Sub-task’) AND [Front].CurrentMember.name = ‘Objetivo’ THEN 0.90\nWHEN [Issue Type].CurrentMember.name = ‘Prearranged’ OR [Issue Type].CurrentMember.name = ‘Prearranged Sub-task’ THEN\n CASE WHEN [Measures].[Issues closed] > 0 AND [Measures].[OB \u2013 Prearranged \u2013 Time to Estimation - Breached] > 0 THEN\n CoalesceEmpty([Measures].[Issues closed] - [Measures].[OB \u2013 Prearranged \u2013 Time to Estimation - Breached] + [Measures].[OB - Prearranged - Time to Estimation - Allegation], 0) /\n [Measures].[Issues closed]\n WHEN [Measures].[Issues closed] > 0 AND IsEmpty([Measures].[OB \u2013 Prearranged \u2013 Time to Estimation - Breached]) THEN 1\n END\nEND”,“format_string”:"#0.00%"},{“name”:“OB - Prearranged - Time to Implementation”,“dimension”:“Measures”,“formula”:“CASE\nWHEN ([Issue Type].CurrentMember.name = ‘Prearranged’ OR [Issue Type].CurrentMember.name = ‘Prearranged Sub-task’) AND [Front].CurrentMember.name = ‘Objetivo’ THEN 0.90\nWHEN [Issue Type].CurrentMember.name = ‘Prearranged’ OR [Issue Type].CurrentMember.name = ‘Prearranged Sub-task’ THEN\n CASE WHEN [Measures].[Issues closed] > 0 THEN\n\t CASE \n WHEN ([Measures].[Issues closed]-[Measures].[Expected PRD Date vs PRD Date] + [Measures].[OB - Prearranged - Time to Implementation - Allegation]) > [Measures].[Issues closed] THEN 1\n WHEN IsEmpty([Measures].[Expected PRD Date vs PRD Date]) THEN 1\n ELSE\n CoalesceEmpty([Measures].[Issues closed]-[Measures].[Expected PRD Date vs PRD Date] + [Measures].[OB - Prearranged - Time to Implementation - Allegation], 0) \n /\n [Measures].[Issues closed]\n END\n END\nEND”,“format_string”:"#0.00%"},{“name”:“OB - Prearranged - Time to Transport”,“dimension”:“Measures”,“formula”:“CASE\nWHEN ([Issue Type].CurrentMember.name = ‘Prearranged’ OR [Issue Type].CurrentMember.name = ‘Prearranged Sub-task’) AND [Front].CurrentMember.name = ‘Objetivo’ THEN 0.90\nWHEN [Issue Type].CurrentMember.name = ‘Prearranged’ OR [Issue Type].CurrentMember.name = ‘Prearranged Sub-task’ THEN\n CASE WHEN [Measures].[Issues closed] > 0 AND [Measures].[OB \u2013 Prearranged \u2013 Time to Transport - Breached] > 0 THEN\n CoalesceEmpty([Measures].[Issues closed] - [Measures].[OB \u2013 Prearranged \u2013 Time to Transport - Breached] + [Measures].[OB - Prearranged - Time to Transport - Allegation], 0) /\n [Measures].[Issues closed]\n WHEN [Measures].[Issues closed] > 0 AND IsEmpty([Measures].[OB \u2013 Prearranged \u2013 Time to Transport - Breached]) THEN \n 1\n END\nEND”,“format_string”:"#0.00%"},{“name”:“OB - Master Data - Time to Implementation”,“dimension”:“Measures”,“formula”:“CASE\nWHEN ([Issue Type].CurrentMember.name = ‘Master Data’ OR [Issue Type].CurrentMember.name = ‘Master Data Sub-task’) AND [Front].CurrentMember.name = ‘Objetivo’ THEN 0.95\nWHEN [Issue Type].CurrentMember.name = ‘Master Data’ OR [Issue Type].CurrentMember.name = ‘Master Data Sub-task’ THEN\n CASE WHEN [Measures].[Issues closed] > 0 AND [Measures].[OB \u2013 Master Data \u2013 Time to Implementation - Breached] > 0 THEN\n CoalesceEmpty([Measures].[Issues closed] - [Measures].[OB \u2013 Master Data \u2013 Time to Implementation - Breached] + [Measures].[OB - Master Data - Time to Implementation - Allegation], 0) /\n [Measures].[Issues closed]\n WHEN [Measures].[Issues closed] > 0 AND IsEmpty([Measures].[OB \u2013 Master Data \u2013 Time to Implementation - Breached]) THEN \n 1\n END\nEND”,“format_string”:"#0.00%"},{“name”:“OB - User Management - Time to Implementation”,“dimension”:“Measures”,“formula”:“CASE\nWHEN ([Issue Type].CurrentMember.name = ‘User Management’ OR [Issue Type].CurrentMember.name = ‘User Management Sub-task’) AND [Front].CurrentMember.name = ‘Objetivo’ THEN 0.95\nWHEN [Issue Type].CurrentMember.name = ‘User Management’ OR [Issue Type].CurrentMember.name = ‘User Management Sub-task’ THEN\n CASE WHEN [Measures].[Issues closed] > 0 AND [Measures].[OB \u2013 User Management \u2013 Time to Implementation - Breached] > 0 THEN\n CoalesceEmpty([Measures].[Issues closed] - [Measures].[OB \u2013 User Management \u2013 Time to Implementation - Breached] + [Measures].[OB - User Management - Time to Implementation - Allegation], 0) /\n [Measures].[Issues closed]\n WHEN [Measures].[Issues closed] > 0 AND IsEmpty([Measures].[OB \u2013 User Management \u2013 Time to Implementation - Breached]) THEN \n 1\n END\nEND”,“format_string”:"#0.00%"},{“name”:“OB - Evolutive - Time to Estimation”,“dimension”:“Measures”,“formula”:"–CASE WHEN ([Issue Type].CurrentMember.name = ‘Evolutive’ OR [Issue Type].CurrentMember.name = ‘Evolutive Sub-task’) AND [Front].CurrentMember.name = ‘Objetivo’ THEN 0.90\n–WHEN [Issue Type].CurrentMember.name = ‘Evolutive’ OR [Issue Type].CurrentMember.name = ‘Evolutive Sub-task’ THEN\n-- CASE WHEN [Measures].[Issues closed] > 0 AND [Measures].[OB \u2013 Evolutive \u2013 Time to Estimation - Breached]> 0 THEN\n-- CoalesceEmpty([Measures].[Issues closed] - [Measures].[OB \u2013 Evolutive \u2013 Time to Estimation - Breached] + [Measures].[OB - Evolutive - Time to Estimation - Allegation], 0) /\n-- [Measures].[Issues closed]\n-- WHEN [Measures].[Issues closed]>0 AND IsEmpty([Measures].[OB \u2013 Evolutive \u2013 Time to Estimation - Breached]) THEN 1\n-- END\n–END\n–\nCASE WHEN ([Issue Type].CurrentMember.name = ‘Evolutive’ OR [Issue Type].CurrentMember.name = ‘Evolutive Sub-task’) AND [Front].CurrentMember.name = ‘Objetivo’ THEN 0.90\nWHEN [Issue Type].CurrentMember.name = ‘Evolutive’ OR [Issue Type].CurrentMember.name = ‘Evolutive Sub-task’ THEN\n CASE WHEN [Measures].[Issues closed] > 0 AND [Measures].[OB - Evolutive Time to Estimation - Closed VS Breached]> 0 THEN\n CoalesceEmpty([Measures].[Issues closed] - [Measures].[OB - Evolutive Time to Estimation - Closed VS Breached] + [Measures].[OB - Evolutive - Time to Estimation - Allegation], 0) /\n [Measures].[Issues closed]\n WHEN [Measures].[Issues closed]>0 AND IsEmpty([Measures].[OB - Evolutive Time to Estimation - Closed VS Breached]) THEN 1\n END\nEND\n",“format_string”:"#0.00%"},{“name”:“OB - Evolutive - Time to Implementation”,“dimension”:“Measures”,“formula”:"–REQ-133209\n–CASE\n–WHEN ([Issue Type].CurrentMember.name = ‘Evolutive’ OR [Issue Type].CurrentMember.name = ‘Evolutive Sub-task’) AND [Front].CurrentMember.name = ‘Objetivo’ THEN 0.90\n–WHEN [Issue Type].CurrentMember.name = ‘Evolutive’ OR [Issue Type].CurrentMember.name = ‘Evolutive Sub-task’ THEN\n-- CASE WHEN [Measures].[Issues closed] > 0 THEN\n–\tCASE\n–\tWHEN ([Measures].[Issues closed]-[Measures].[Expected UAT Date vs UAT Date] + [Measures].[OB - Evolutive - Time to Implementation - Allegation]) > [Measures].[Issues closed] THEN 1\n–\t\tWHEN IsEmpty([Measures].[Expected UAT Date vs UAT Date]) THEN 1\n–\t\tELSE\n–\t\t\tCoalesceEmpty(([Measures].[Issues closed]-[Measures].[Expected UAT Date vs UAT Date] + [Measures].[OB - Evolutive - Time to Implementation - Allegation]), 0) \n–\t\t\t/\n–\t\t\t[Measures].[Issues closed]\n–\tEND\n-- END\n–END\n-- fin\nCASE WHEN [Issue].CurrentMember.Level.Name <> ‘Issue’ THEN\n\n CASE WHEN ([Issue Type].CurrentMember.name = ‘Evolutive’ OR [Issue Type].CurrentMember.name = ‘Evolutive Sub-task’) AND \n ([Measures].[Issues closed] > 0) THEN\n\nCoalesceEmpty(([Measures].[Issues closed]-[Measures].[Expected UAT Date vs UAT Date]+ [Measures].[OB - Evolutive - Time to Implementation - Allegation]), 0) /\n [Measures].[Issues closed]\n END\nELSE\nCASE WHEN ([Issue Type].CurrentMember.name = ‘Evolutive’ OR [Issue Type].CurrentMember.name = ‘Evolutive Sub-task’) AND [Front].CurrentMember.name = ‘Objetivo’ THEN 0.90\nWHEN [Issue Type].CurrentMember.name = ‘Evolutive’ OR [Issue Type].CurrentMember.name = ‘Evolutive Sub-task’ THEN\n CASE WHEN [Measures].[Issues closed] > 0 THEN\n IIf(IsEmpty([Measures].[Expected UAT Date vs UAT Date]),1,\nCoalesceEmpty(([Measures].[Issues closed]- [Measures].[Expected UAT Date vs UAT Date]+ [Measures].[OB - Evolutive - Time to Implementation - Allegation]), 0) /\n [Measures].[Issues closed])\n\tEND\nEND\nEND\n",“format_string”:"#0.00%"},{“name”:“OB - Evolutive - Time to Transport”,“dimension”:“Measures”,“formula”:“CASE\nWHEN ([Issue Type].CurrentMember.name = ‘Evolutive’ OR [Issue Type].CurrentMember.name = ‘Evolutive Sub-task’) AND [Front].CurrentMember.name = ‘Objetivo’ THEN 0.90\nWHEN [Issue Type].CurrentMember.name = ‘Evolutive’ OR [Issue Type].CurrentMember.name = ‘Evolutive Sub-task’ THEN\n CASE WHEN [Measures].[Issues closed] > 0 THEN\n\tCASE\n\t\tWHEN ([Measures].[Issues closed]-[Measures].[Expected PRD Date vs PRD Date] + [Measures].[OB - Evolutive - Time to Transport - Allegation]) > [Measures].[Issues closed] THEN 1\n\t\tWHEN IsEmpty([Measures].[Expected PRD Date vs PRD Date]) THEN 1\n\t\tELSE\n\t\t\tCoalesceEmpty(([Measures].[Issues closed]-[Measures].[Expected PRD Date vs PRD Date] + [Measures].[OB - Evolutive - Time to Transport - Allegation]), 0) \n\t\t\t/\n\t\t\t[Measures].[Issues closed]\n\tEND\n END\nEND”,“format_string”:"#0.00%"},{“name”:“Expected PRD Date vs PRD Date”,“dimension”:“Measures”,“formula”:"–REQ-133209\n–Cache(\n–CASE WHEN [Issue].CurrentMember.Level.Name <> ‘Issue’ THEN\n-- CASE\n-- WHEN [Measures].[Issues with expected PRD date] > 0 AND [Measures].[Issues with prd date] > 0 THEN\n-- Count(\n-- Filter(\n-- Descendants([Issue].CurrentMember, [Issue].[Issue]),\n-- D–ateInPeriod([Issue].CurrentMember.get(‘Closed at’),[Time].CurrentHierarchyMember)\n-- A–ND\n-- [–Measures].[Issues closed]>0\n-- A–ND\n-- [Measures].[Issues with expected PRD date] > 0\n-- AND\n-- [Measures].[Issues with prd date] > 0\n-- AND\n-- DateCompare([Issue].CurrentMember.get(‘PRD Date’), [Issue].CurrentMember.get(‘Expected PRD Date’)) > 0\n-- )\n-- )\n-- END\n–ELSE\n-- CASE\n-- WHEN [Measures].[Issues with expected PRD date] > 0 AND [Measures].[Issues with prd date] > 0 AND [Measures].[Issues closed]>0 THEN\n-- CASE\n-- WHEN DateCompare([Issue].CurrentMember.get(‘PRD Date’), [Issue].CurrentMember.get(‘Expected PRD Date’)) > 0 THEN 1\n-- END\n-- END\n–END\n–)\n-- fin\n\nCache(\n\nCASE WHEN [Issue].CurrentMember.Level.Name <> ‘Issue’ THEN\n CASE\n WHEN [Measures].[Issues with expected PRD date] > 0 OR [Measures].[Issues with prd date] > 0 THEN\n Sum(\n Filter(\n Descendants([Issue].CurrentMember, [Issue].[Issue]),\n DateInPeriod([Issue].CurrentMember.get(‘Closed at’),[Time].CurrentHierarchyMember)\n AND\n DateCompare([Issue].CurrentMember.get(‘PRD Date’), [Issue].CurrentMember.get(‘Expected PRD Date’)) > 0\n ),\n [Measures].[Issues closed]\n )\n END\nELSE\n CASE\n WHEN ([Measures].[Issues with expected PRD date] > 0 OR [Measures].[Issues with prd date] > 0) AND [Measures].[Issues closed]>0 THEN\n CASE\n WHEN DateCompare([Issue].CurrentMember.get(‘PRD Date’), [Issue].CurrentMember.get(‘Expected PRD Date’)) > 0 THEN 1\n END\n END\nEND\n)\n",“format_string”:""},{“name”:“Expected UAT Date vs UAT Date”,“dimension”:“Measures”,“formula”:"-- REQ-133209\n–CASE WHEN [Issue].CurrentMember.Level.Name <> ‘Issue’ THEN\n-- CASE\n-- WHEN [Measures].[Issues with expected uat date] > 0 AND [Measures].[Issues with uat date] > 0 THEN\n-- Cache( \n-- SUM(\n-- Filter(\n-- Descendants([Issue].CurrentMember, [Issue].[Issue]),\n-- DateInPeriod(\n-- [Issue].CurrentMember.get(‘Closed at’),\n-- [Time].CurrentHierarchyMember)\n-- AND \n-- DateInPeriod(\n-- [Issue].CurrentMember.get(‘UAT Date’),\n-- [Time].CurrentHierarchyMember)\n-- AND \n-- DateInPeriod(\n-- [Issue].CurrentMember.get(‘Expected UAT Date’),\n-- [Time].CurrentHierarchyMember)\n-- AND DateCompare([Issue].CurrentMember.get(‘UAT Date’),[Issue].CurrentMember.get(‘Expected UAT Date’)) > 0 \n-- ),\n-- [Measures].[Issues closed count]\n-- )\n-- )\n-- END\n–ELSE\n-- CASE\n-- WHEN [Measures].[Issues with expected uat date] > 0 AND [Measures].[Issues with uat date] > 0 AND [Measures].[Issues closed] > 0 THEN\n-- Cache( \n-- SUM(\n-- Filter(\n-- Descendants([Issue].CurrentMember, [Issue].[Issue]),\n-- DateInPeriod(\n-- [Issue].CurrentMember.get(‘Closed at’),\n-- [Time].CurrentHierarchyMember)\n-- AND \n-- DateInPeriod(\n-- [Issue].CurrentMember.get(‘UAT Date’),\n-- [Time].CurrentHierarchyMember)\n-- AND \n-- DateInPeriod(\n-- [Issue].CurrentMember.get(‘Expected UAT Date’),\n-- [Time].CurrentHierarchyMember)\n-- AND DateCompare([Issue].CurrentMember.get(‘UAT Date’),[Issue].CurrentMember.get(‘Expected UAT Date’)) > 0 \n-- ),\n-- [Measures].[Issues closed count]\n-- )\n-- )\n-- WHEN DateCompare([Issue].CurrentMember.get(‘UAT Date’),[Issue].CurrentMember.get(‘Expected UAT Date’)) > 0 THEN 1\n-- END\n-- END\n–END\n\n-- fin\n\nCASE WHEN [Issue].CurrentMember.Level.Name <> ‘Issue’ THEN\n Cache( \n SUM(\n Filter(\n Descendants([Issue].CurrentMember, [Issue].[Issue]),\n DateCompare([Issue].CurrentMember.get(‘UAT Date’),[Issue].CurrentMember.get(‘Expected UAT Date’)) > 0 \n AND\n DateInPeriod(\n [Issue].CurrentMember.get(‘Closed at’),\n [Time].CurrentHierarchyMember)\n ),\n [Measures].[Issues closed]\n )\n )\n\nELSE\n CASE\n WHEN [Measures].[Issues with expected uat date] > 0 AND [Measures].[Issues with uat date] > 0 AND [Measures].[Issues closed] > 0 THEN\n Cache( \n SUM(\n Filter(\n Descendants([Issue].CurrentMember, [Issue].[Issue]),\n DateInPeriod(\n [Issue].CurrentMember.get(‘Closed at’),\n [Time].CurrentHierarchyMember)\n AND \n DateInPeriod(\n [Issue].CurrentMember.get(‘UAT Date’),\n [Time].CurrentHierarchyMember)\n AND \n DateInPeriod(\n [Issue].CurrentMember.get(‘Expected UAT Date’),\n [Time].CurrentHierarchyMember)\n AND DateCompare([Issue].CurrentMember.get(‘UAT Date’),[Issue].CurrentMember.get(‘Expected UAT Date’)) > 0 \n ),\n [Measures].[Issues closed count]\n )\n )\n WHEN DateCompare([Issue].CurrentMember.get(‘UAT Date’),[Issue].CurrentMember.get(‘Expected UAT Date’)) > 0 THEN 1\n END\n END\nEND\n",“format_string”:""},{“name”:“OB - Corrective - Time to Test - Allegation”,“dimension”:“Measures”,“formula”:"(\n [Measures].[OB - Corrective - Time to Test - Allegation closed],\n [OB \u2013 Corrective \u2013 Time to Test Breached].[Breached]\n)",“format_string”:""},{“name”:“OB - Corrective - Time to Transport - Allegation”,“dimension”:“Measures”,“formula”:"(\n [Measures].[OB - Corrective - Time to Transport - Allegation closed],\n [OB \u2013 Corrective \u2013 Time to Transport Breached].[Breached]\n)",“format_string”:""},{“name”:“OB - Support - Time to Estimation - Allegation”,“dimension”:“Measures”,“formula”:"(\n [Measures].[OB - Support - Time to Estimation - Allegation closed],\n [OB \u2013 Support \u2013 Time to Estimation Breached].[Breached]\n)",“format_string”:""},{“name”:“OB - Support - Time to Implementation - Allegation”,“dimension”:“Measures”,“formula”:"(\n [Measures].[OB - Support - Time to Implementation - Allegation closed],\n [OB \u2013 Support \u2013 Time to Implementation Breached].[Breached]\n)",“format_string”:""},{“name”:“OB - Prearranged - Time to Estimation - Allegation”,“dimension”:“Measures”,“formula”:"(\n [Measures].[OB - Prearranged - Time to Estimation - Allegation closed],\n [OB \u2013 Prearranged \u2013 Time to Estimation Breached].[Breached]\n)",“format_string”:""},{“name”:“OB - Prearranged - Time to Implementation - Allegation”,“dimension”:“Measures”,“formula”:"(\n [Measures].[Prearranged - Time to Implementation - Allegation closed],\n [OB - Prearranged - Time to Implementation].[Breached]\n)",“format_string”:""},{“name”:“OB - Prearranged - Time to Transport - Allegation”,“dimension”:“Measures”,“formula”:"(\n [Measures].[OB - Prearranged - Time to Transport - Allegation closed],\n [OB \u2013 Prearranged \u2013 Time to Transport Breached].[Breached]\n)",“format_string”:""},{“name”:“OB - Master Data - Time to Implementation - Allegation”,“dimension”:“Measures”,“formula”:"(\n [Measures].[OB - Master Data - Time to Implementation - Allegation closed],\n [OB \u2013 Master Data \u2013 Time to Implementation Breached].[Breached]\n)",“format_string”:""},{“name”:“OB - User Management - Time to Implementation - Allegation”,“dimension”:“Measures”,“formula”:"(\n [Measures].[OB - User Management - Time to Implementation - Allegation closed],\n [OB \u2013 User Management \u2013 Time to Implementation Breached].[Breached]\n)",“format_string”:""},{“name”:“OB - Evolutive - Time to Estimation - Allegation”,“dimension”:“Measures”,“formula”:"(\n [Measures].[OB - Evolutive - Time to Estimation - Allegation closed],\n [OB \u2013 Evolutive \u2013 Time to Estimation Breached].[Breached]\n)",“format_string”:""},{“name”:“OB - Evolutive - Time to Implementation - Allegation”,“dimension”:“Measures”,“formula”:"(\n [Measures].[Evolutive - Time to Implementation - Allegation closed],\n [OB - Evolutive - Time to Implementation].[Breached]\n)",“format_string”:""},{“name”:“OB - Evolutive - Time to Transport - Allegation”,“dimension”:“Measures”,“formula”:"(\n [Measures].[OB - Evolutive - Time to Transport - Allegation closed],\n [OB - Evolutive - Time to Transport].[Breached]\n)",“format_string”:""},{“name”:“OB - Evolutive Time to Estimation - Closed VS Breached”,“dimension”:“Measures”,“formula”:“Cache(\n\nNonZero(\nSUM(\nFilter(\nDescendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),\n[Measures].[Issues closed]>0\n),\n(\n[Measures].[OB \u2013 Evolutive \u2013 Time to Estimation Issues], \n[OB \u2013 Evolutive \u2013 Time to Estimation Breached].[Breached],\n[Time].CurrentHierarchy.DefaultMember\n)\n)\n)\n)”,“format_string”:""},{“name”:“Previous-month”,“dimension”:“Time”,“formula”:"[Time].[Month].CurrentDateMember.PrevMember\n",“format_string”:""}]
}

Drill issues, each of them have 100% but the total show 91.%
Dont know how to show 0 not completed issues

Hi,
A likely reason for not seeing all the issues is that the drill through option does not show in the list of issues with zero.
Let me show that with a simple test report:
cd0ef3b297d50bf51754d4bd735ef79f.png
When I drill through, I will see 100% issues only:
59166e63ee9177eee4d9ab4fc848a645.png

There are, however, other issues, and the recommended solution is to use the drill-across function:
f9e03299d51c6db118922fc9d8f638e4.png
875fddbd886fc0a3f88d3aaab0af10d1.png

Kindly,
Janis, eazyBI support

This works,

Thanks in advance.