Display products with sales in the latest month in a matrix showing rolling 6-month sales

[gauthamboppana]

Hi all,

I have a Matrix Visual showing rolling 6 months sales by Product.  The one requirement is to hide the products that do not have any sales in the latest period. For exmaple, in the below screenshot I have selected Dec 2024. There are no sales for Product E. So product E should not be displayed in the Matrix.

Can any one help? 

I have attached the sample PBIX file.
Linkt-To-Downlaod-Sample-PBIX-File 

This is my DAX formula for calculating the last 6 months sales.

SalesLast6Months =

VAR MaxVisibleDate = MAX('DateTable'[Date])

VAR MinVisibleDate = EDATE(MaxVisibleDate, -5)  -- 6 months

RETURN

CALCULATE(

    SUM(Sales[SalesAmount]),

    FILTER(

        ALL('DateTable'),

        'DateTable'[Date] <= MaxVisibleDate &&

        'DateTable'[Date] >= MinVisibleDate

    )

)

Thank you

[Selva-Salimi]

Hi @gauthamboppana 

 you can update your measure as follows:

SalesLast6Months =

VAR MaxVisibleDate = MAX('DateTable'[Date])

VAR MinVisibleDate = EDATE(MaxVisibleDate, -5)  -- 6 months

VAR Last_Products = Summarize(filter(sales , sales[date] = maxVisibleDate) , [Products])

RETURN

CALCULATE(

    SUM(Sales[SalesAmount]),

    FILTER(

        ALL('DateTable'),

        'DateTable'[Date] <= MaxVisibleDate &&

        'DateTable'[Date] >= MinVisibleDate

    ) , 

     Filter (Sales , Sales [Product] in Last_products )

)

If this post helps, then I would appreciate a thumbs up  and mark it as the solution to help the other members find it more quickly.