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

     

Shahid12523's avatar
Shahid12523
Icon for Community Champion rankCommunity Champion
10 months ago

DAX Measure: Count for Max Week


ResolvedCount_MaxWeek =
CALCULATE(
COUNTROWS('YourTable'),
FILTER(
'YourTable',
'YourTable'[Week] = CALCULATE(MAX('YourTable'[Week]))
)
)