Forum Discussion
PaulJ185
10 months agoNew Member
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.
- 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
Community Support
10 months agoHi PaulJ185,
We are following up to see if what we shared solved your issue. If you need more support, please reach out to the Microsoft Fabric community.
Thank you.