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


Anonymous's avatar
Anonymous
Not applicable
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
)
)