This is for a super article which belongs to priority level 3.
The filter is used on the dimension Item.
In my tables there's no problem using this type of filtering for the items I don't want to see.
However, I don't seem to be able to incorporate this in a measure NOT in a table, which is due to there not being a structure anymore. I tried to solve this with the Aggr function, but it seems I can't figure it out.
For Order 220150, we've got Item 40. Item 40 is built up out a number of articles, of which 3 super articles which belong to different priority levels.
Through the filter for a super article which belongs to priority level 2, I can determine it is shown under the correct super article.
The filter is done based on a Concat of the filter weight of all the articles(products) under the item:
What I want to achieve is that I can make the Sum(# Net Amount) based on this filterting.
Which works fine in the table above, as we got a structure of Document Number ==> Item ==> Product.
But when I want to make a measure for the Sum(# Net Amount) for a super article belonging to priority level 2 in a KPI, I can't seem to get it to work through an Aggr function.
Is it possible to edit the filtering so it's usable in a measure outside of a table?
P.S.: As attachement, I've put an Excel with the data shown in the screenshots.