Forum Discussion
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 ...
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
)
)
Hey Anonymous this worked as intended. Thanks!