Power Bi -> Max_value and Count

Hi Molika  -  Create These Two Measures as follows:

Min_Date_Filtered = MIN('YourTable'[Date])
Max_Date_Filtered = MAX('YourTable'[Date])

 

You want to count how many times each id appears in the filtered table

Count_Dates_Per_ID =
CALCULATE(
COUNTROWS('YourTable'),
ALLEXCEPT('YourTable', 'YourTable'[id])
)

 

It respect the slicer (filtered Date column)

Return 1 for ID 134 and 141

Return 2 for ID 164 (as it appears with two different dates)

 

Hope this helps, pelase check.

Hi Molika,

Thanks for using Microsoft Fabric Community Forum.

 

To ensure that the minimum and maximum date values calculate correctly even when the Date column is present in the visual, you must use DAX measures that remove the row context introduced by the Date column while still respecting the applied filters or slicers.

To fix the issue where the count includes dates not selected in the filter (e.g., 26.01.2025), you need to write the measure in a way that:

Groups by ID using ALLEXCEPT

Preserves filter context from slicers or visuals using KEEPFILTERS or similar

This approach ensures Min_Date and Max_Date return consistent values for all rows, regardless of Date being in the table. And the Count for each ID includes only the dates currently selected (e.g., 2 for ID 164, excluding 26.01.2025).

 

I hope my suggestions provided valuable insights. If you have any further questions, don’t hesitate to ask in a follow-up message.
If this post helped, please mark it as "Accept as Solution" so others can benefit as well.

 

Best regards,
Sahasra.

Hi Molika,

 

Please follow below steps.

1. I have created sample table(Table) and columns (ID and Date).
2. Created MIN and MAX Measures with below DAX.

 

Min_Date = MIN('Table'[Date])
Max_Date = MAX('Table'[Date])

 

3. Count of Dates per ID's : 

   Created below measure for Date count per ID.

DateCountPerID = 
CALCULATE(
    COUNTROWS('Table'),
    ALLEXCEPT('Table', 'Table'[ID])
)

 

4. In Table visual, drag all the columns and drag Date column to slicer.

 

Please refer below attached snaps for your reference.

Please follow below steps.

 

1. I have created sample table(Table) and columns (ID and Date).
2. Created MIN and MAX Measures with below DAX.

 

Min_Date = MIN('Table'[Date])
Max_Date = MAX('Table'[Date])

 

3. Count of Dates per ID's : 

   Created below measure for Date count per ID.

DateCountPerID = 
CALCULATE(
    COUNTROWS('Table'),
    ALLEXCEPT('Table', 'Table'[ID])
)

 

4. In Table visual, drag all the columns and drag Date column to slicer.

 

Please refer below attached snaps for your reference.

 

 

If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!

 

Thank you.