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

     

v-pnaroju-msft's avatar
v-pnaroju-msft
Icon for Community Support rankCommunity Support
10 months ago

Thankyou, Khashayar, Shahid12523, Kedar_Pande, and danextian for your responses.

Hi PaulJ185,

We appreciate your inquiry through the Microsoft Fabric Community Forum.

We would like to inquire whether have you got the chance to check the solutions provided by Khashayar, Shahid12523, Kedar_Pande and danextian  to resolve the issue. We hope the information provided helps to clear the query. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

Thank you.