Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to include a filter in a topN dax function?

I want to include a filter in my dax function but not sure how?   see below my new table formula (works fine)     Top5Products = TOPN( 5, SUMMARIZE( 'DimProduct', 'DimP...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Why dont you add this filter before the summarize

    Top5Products =

    TOPN(

        5,

        Filter(SUMMARIZE(

            'DimProduct',

            'DimProduct'[ProductFlag],

            'DimProduct'[ProductID],

            'DimProduct'[ProductKey],

            'DimProduct'[ProductName],

            "Products",

            SUM('FctSales'[TotalVolume])

        ),'DimProduct'[ProductFlag]<>"False"),

        [Providers]

    )

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Why dont you add this filter before the summarize

Top5Products =

TOPN(

    5,

    Filter(SUMMARIZE(

        'DimProduct',

        'DimProduct'[ProductFlag],

        'DimProduct'[ProductID],

        'DimProduct'[ProductKey],

        'DimProduct'[ProductName],

        "Products",

        SUM('FctSales'[TotalVolume])

    ),'DimProduct'[ProductFlag]<>"False"),

    [Providers]

)

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Perfect! Thank you james