Trouble implementing treatas()

Hi,

According to your description, i think you have at least three tables and the problem you have due to no relationship berween another two tables.

So i create three tables to test:

And for your second measure, i make some changes to it:

measure 2 =
CALCULATE (
    DIVIDE (
        SUM ( Position[MARKET_TOTAL_IN_EUR] ),
        CALCULATE (
            SUM ( Position[MARKET_TOTAL_IN_EUR] ),
            ALLSELECTED ( Security[CLASS2] ),
            ALLSELECTED ( Security[NAME1] ),
            TREATAS ( VALUES ( Index[CLASS2] ), Security[CLASS2] ),
            TREATAS ( VALUES ( Security[NAME1] ), Position[name1] )
        )
    )
)

The result shows:

Here is my test pbix file:

pbix 

Best Regards,

Giotto Zhi