Filter within TOPN

Hi,

Could you please check if the below measure works? 

new measure =
CALCULATE (
    [Total Sales],
    KEEPFILTERS (
        TOPN (
            10,
            SUMMARIZE (
                FILTER (
                    SUMMARIZE (
                        ALL ( DimCustomer ),
                        DimCustomer[FirstName],
                        DimCustomer[Is parent]
                    ),
                    DimCustomer[Is parent] = "Parent"
                ),
                DimCustomer[FirstName]
            ),
            [Total Sales]
        )
    )
)

Hi,

After I see your pbix file, I am confused and I am not sure what you want to visualize.

Do you want to rank total sales by First name? For example, I see that there are so many "Aaron"s and some of them are parent and some of them are Not parent.

I think you can put a correct column in the visualization to check top sales.

I did not check whether the measures still work, but I inside the TOPN function in each measure, including TOP sales measure, please select the correct column, or you can just select the whole table if there are other columns involved such as sorting purpose, for instance.

Thanks.

Thanks.