• I found my behavior that is causing this to be a calculated member

    I have create the following tendency

    (IIF([Measures].[Age]=TRUE,1,0)+

    IIF([Measures].[Idle]=TRUE,1,0)+

    IIF([Measures].[Labor]=TRUE,1,0))/3

    My issue is that in excel if I use this (or the kpi) the heritages aren't take in account and each heiritable show all possible results instead of

    ignore those that is suppose to be filter by.

    Example

    It should show

    America USA 1 1 0 OK Colombia 1 0 1 OK Brazil 0 0 0 Bad Asia Japan 1 1 1 OK

    But instead it shows

    America USA 1 1 0 OK Colombia 1 0 1 OK Brazil 0 0 0 Bad Japan OK Asia USA OK Colombia OK Brazil Bad Japan 1 1 1 OK

    Can anyone point me what I am doing wrong?