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]

    )

tackytechtom's avatar
tackytechtom
Most Valuable Professional
4 years ago

Hi Anonymous 

 

Does it work with this one?

Top5Products = 
TOPN(
    5,
    SUMMARIZE(
        FILTER ( 'DimProduct', 'DimProduct'[ProductFlag] <> "False" )
        'DimProduct'[ProductFlag],
        'DimProduct'[ProductID],
        'DimProduct'[ProductKey],
        'DimProduct'[ProductName],
        "Products",
        SUM('FctSales'[TotalVolume])
    ),
    [Providers]
)

 

Let me know if this works for you 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/