Max Count on a certain date base from date Slicer

Try the following, add more columns as needed

MAXX (
    -- SUMMARIZECOLUMNS creates a table grouped by Partner and Trade
    -- and adds a calculated column "@max" using [POB Max Measure]
    SUMMARIZECOLUMNS(
        'table'[Partner],   -- group by Partner
        'table'[Trade],     -- group by Trade
        "@max", [POB Max Measure]  -- calculate the max value per group
    ),
    [@max]  -- MAXX iterates over the summarized table and returns the maximum of the "@max" column
)

the max will evaluated for each combination of the columns added.

Thankyou, danextian, for your response.

Hi AllanBerces,

We appreciate your question on the Microsoft Fabric Community Forum.

Based on my understanding of the scenario, please find attached a screenshot and a sample PBIX file that may assist in resolving the matter:

We hope the information provided helps to resolve the issue. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

Thank you.