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] )

     

Kedar_Pande's avatar
Kedar_Pande
Icon for Super User rankSuper User
10 months ago
Resolved Count for Max Week =
VAR MaxWeek = CALCULATE(MAX('Table'[Week]), ALL('Table'))
RETURN
CALCULATE(
COUNT('Table'[Resolved Date]),
'Table'[Week] = MaxWeek
)