Skip to Content
0
Aug 23, 2023 at 11:28 PM

Restricted Measure with YTD Measure not working properly

129 Views

Hello everyone,

We're facing an issue with a calculated measure in one of our models. First of all, we've created a calculated measure in the modeler called YTD_TML to calculate YTD values in our model:

calc-measaure.png

If we use the measure within a table with the time dimension on any axis, it will work as expected:

calc-measaure2.png

But if we configure a restricted measure, setting the target month as April 2023 for a YTD value and the time dimension is not present in any axis, it won't work as we need it (we expect 606,243 and we receive 148,162, the periodic value of April):

calc-measaure4.png

Any ideas what are we doing wrong? For our requirement is not possible to include the time dimension in the axis of the report, because we're creating different restricted measures for each column making reference to different data regions in each one.

Thanks in advance.

Andrés

Attachments

calc-measaure.png (30.0 kB)
calc-measaure2.png (24.7 kB)
calc-measaure4.png (70.6 kB)