Max Count on a certain date base from date Slicer

[AllanBerces]

Hi good day can anyone help me on my measure. i have table with column date, location, Trade and Partner. table is connected to my calendar table. From my calendar table i created filter

What i required is if i filter the date range let say from Feb 01 to July 20 2025 it will show the Max count number of Trade on the paticular date on the date range i filter 

Someting like this the result i required

Card:

Table

Thank you

[danextian · Accepted solution]

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.

[v-pnaroju-msft · Accepted solution]

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.

[AllanBerces]

Hi @danextian @v-pnaroju-msft thank you very much for the reply, work as i need

[danextian]

Is POB Max a measure or a column? If a column you can just use MAX ('Table'[POB Max]).

[AllanBerces]

Hi @danextian thank you very much for the reply, POB max (trade) is the result of the measure that i;m asking for help on how can i arrive base from my table with column date, location, Trade and Partner

[danextian · Accepted solution]

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.