fix values to a dimension

[JoannaM]

Hi all

I have a measure which shows the last booked quantity in a production order. When I select this specific production order (dimension) then the measure is shown correctly. However, if i look this production order up in the table, the measures are gone.

Prodution order selected with thte correct measure:

My formula (thanks to Sammy_AK) in set analysis:

sum(
aggr(
only({<[goods issue PO] = {$(=max({<[goods issue PO]>}[goods issue PO]))}>}[goods issue PO])
,[goods issue PO],[%production order])
)

In table not showing when filter isnt't used:

How can I bind the measure to the production order?

Thanks a lot for the help.

BR, Joanna

[MayilVahanan]

Hi Joanna,

Try like below

sum(
aggr(
Sum({<[goods issue PO] = {$(=max({<[goods issue PO]>}[goods issue PO]))}>}[goods issue PO])
,[goods issue PO],[%production order])
)

Or

sum(
aggr(
Max({<[goods issue PO] = {$(=max({<[goods issue PO]>}[goods issue PO]))}>}[goods issue PO])
,[goods issue PO],[%production order])
)

Depends on ur requirement.

[JoannaM]

Hi Mayil

Thank you for your fast input. Unfortunately, with your suggestions I still have the same outcome.

The meaures are not showing when the filter is not set to the production order.

BR, Joanna

[MayilVahanan]

Hi @JoannaM 

Can you share the sample file to verify

[JoannaM]

Hi Mayil

Unfortunately,  I am not allowed to share a sample file.

Thank you.

BR, Joanna