Forum Discussion

PaulJ185's avatar
PaulJ185
New Member
10 months ago
Solved

Need Help with Dax Calculations | Count Resolved Date only for MAX Week Numbers

Hi There,   I wantto countresoved date only for max week which is 45 in my dataset and row count is 3.   Expected answer= Resoved Date is 3.
Need Help
  • danextian's avatar
    danextian
    10 months ago

    Hi PaulJ185 

     

    Assuming week is a measure

    Resolved date with max week - Count = 
VAR _SummaryTable =
    SUMMARIZECOLUMNS (
        'Table'[Resolved Date],
        "@week", CALCULATE ( SUM ( 'Table'[Week] ) )
    )
VAR _Max =
    MAXX ( _SummaryTable, [@week] )
RETURN
COUNTROWS ( FILTER ( _SummaryTable, [@week] = _Max ) )

Resolved date with max week = 
VAR _SummaryTable =
    SUMMARIZECOLUMNS (
        'Table'[Resolved Date],
        "@week", CALCULATE ( SUM ( 'Table'[Week] ) )
    )
VAR _Max =
    MAXX ( _SummaryTable, [@week] )
RETURN
MAXX ( FILTER ( _SummaryTable, [@week] = _Max ), [Resolved Date] )

     

Khashayar's avatar
Khashayar
Icon for Resolver I rankResolver I
10 months ago

You want to count the number of Resolved Dates only for the maximum week (Week = 45) in your dataset.
In Power BI (DAX), you can use this measure:

Resolved Count =

VAR MaxWeek = MAX('YourTable'[Week])

RETURN

COUNTROWS(

    FILTER(

        'YourTable',

        'YourTable'[Week] = MaxWeek

    )

)

Explanation:

  • MAX('YourTable'[Week]) → finds the highest week number (45).
  • FILTER() → keeps only rows where [Week] = 45.
  • COUNTROWS() → counts how many rows meet that condition.

Expected Result:

Resolved Count = 3

If you found this post helpful, please consider accepting it as the solution so that other members can find it more easily.

 

Regards,

Khashayar Yazdani | Microsoft MCT

https://www.linkedin.com/in/khashayary/