[Measure].[Pages Published] = [Measures].[Issues created]
So that’s pretty straightforward. And in fact, just replace it with Issues Created in the report and other than the label changing, we get the same error and behaviour.
Also, for the below report export, you might need to know that:
[Measure].[Missed Planned] = nonzero(
count(
Filter(
Generate(
ChildrenSet([Issue].CurrentHierarchyMember),Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue])
),
[Measures].[Issues created]>0 AND DateDiffDays([Measures].[Issue Go Live Date], [Measures].[Issue Embargo Date/Time]) < 0
)
)
)
The report definition is:
{
“cube_name”: “Issues”,
“cube_reports”: [ {
“name”: “Non-Product Launch Pages Published/Missed”,
“folder_name”: “Publishing”,
“result_view”: “bar_chart”,
“definition”: {“columns”:{“dimensions”:[{“name”:“Measures”,“selected_set”:[“[Measures].[Pages Published]”,“[Measures].[Missed Planned]”],“members”:[]}]},“rows”:{“dimensions”:[{“name”:“Time”,“selected_set”:[“[Time].[Month].Members”],“members”:[],“bookmarked_members”:[]},{“name”:“Issue Type”,“selected_set”:[“[Issue Type].[All Page Publish Types]”],“members”:[],“bookmarked_members”:[{“depth”:1,“name”:“Task”,“full_name”:“[Issue Type].[Task]”}]},{“name”:“Project”,“selected_set”:[“[Project].[MS-Publishing]”],“members”:[],“bookmarked_members”:[{“depth”:1,“name”:“MS-Publishing”,“full_name”:“[Project].[MS-Publishing]”,“drillable”:true,“key”:“MSPUB”}]},{“name”:“Issue”,“selected_set”:[“[Issue].[not PLs]”],“members”:[],“bookmarked_members”:[]}],“filter_by”:{“conditions”:[{“expression”:“[Time].CurrentHierarchyMember”,“operator”:“between”,“value”:“5 months ago and today”,“value_type”:“date”}]},“nonempty_crossjoin”:true},“pages”:{“dimensions”:[{“name”:“Business Unit”,“selected_set”:[“[Business Unit].[All Business Units]”],“members”:[{“depth”:0,“name”:“All Business Units”,“full_name”:“[Business Unit].[All Business Units]”,“drillable”:true,“type”:“all”}],“bookmarked_members”:[],“current_page_members”:[“[Business Unit].[All Business Units]”]}]},“options”:{},“view”:{“current”:“bar_chart”,“maximized”:false,“bar_chart”:{“stacked”:true,“vertical”:false,“swap_axes”:false,“data_labels”:true,“series_options”:{}},“table”:{}}}
} ],
“calculated_members”: [{“name”:“Issue Embargo Date/Time”,“dimension”:“Measures”,“formula”:“[Issue].CurrentHierarchyMember.get(‘Embargo Date/Time’)”,“format_string”:“mmm dd yyyy”},{“name”:“Issue Go Live Date”,“dimension”:“Measures”,“formula”:“[Issue].CurrentHierarchyMember.get(‘Go Live Date’)”,“format_string”:“mmm dd yyyy”},{“name”:“Missed Embargo”,“dimension”:“Measures”,“formula”:“nonzero(\n count(\n Filter(\n Generate(\n ChildrenSet([Issue].CurrentHierarchyMember),Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue])\n ),\n [Measures].[Issues created]\u003e0 AND DateDiffDays([Measures].[Issue Go Live Date], [Measures].[Issue Embargo Date/Time]) \u003c 0\n )\n )\n)”,“format_string”:“#,##0”},{“name”:“not PLs”,“dimension”:“Issue”,“formula”:“Aggregate(\n Filter([Issue].[Issue].Members,\n [Issue].CurrentMember.Name not matches ‘.PL.’\n )\n)”,“format_string”:“”},{“name”:“Pages Published”,“dimension”:“Measures”,“formula”:“[Measures].[Issues created]”,“format_string”:“”},{“name”:“Missed Planned”,“dimension”:“Measures”,“formula”:“[Measures].[Missed Embargo]”,“format_string”:“”},{“name”:“All Page Publish Types”,“dimension”:“Issue Type”,“formula”:“[Issue Type].[MS - Support Content]+\n[Issue Type].[MSPUB - Web Content]+\n[Issue Type].[MS - App Content]”,“format_string”:“”}]
}