Forum Discussion

htbull_'s avatar
htbull_
Frequent Visitor
1 year ago
Solved

Trouble aggregating Measure results in a Table

Hello all,    I'm having some trouble in getting some measure results to accurately total and display across all of the desired reporting years.  I have created a measure to count the rows with a ...
General Comment
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi htbull_ 
    Please try this
    _ClaimsOpened :=
    CALCULATE(
    COUNTROWS(ClaimInfoHistory),


    FILTER(
    ClaimInfoHistory,
    [IsLatestClaimFlag] = 1 &&
    ClaimInfoHistory[StatusID] = 352 
    ),

    Ensure calendar relationship is used correctly
    USERELATIONSHIP(ClaimInfoHistory[SaveDate], Calendar_History[Date])
    )


    _TotalClaimsOpened :=
    CALCULATE(
    COUNTROWS(ClaimInfoHistory),
    FILTER(
    ALL(ClaimInfoHistory), 
    [IsLatestClaimFlag] = 1 &&
    ClaimInfoHistory[StatusID] = 352
    )
    )


v-veshwara-msft's avatar
v-veshwara-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi htbull_ ,
Thanks for posting in Microsoft Fabric Community.

Just checking in to see if you query is resolved.

The approach suggested by Anonymous  is correct. By having _ClaimsOpened respect the calendar relationship and flag logic, and _TotalClaimsOpened use ALL to ignore row context, the calculation ensures that the row-level results and the total are both evaluated correctly.

 

If you still need assistance, please let us know.
Thank you.