Forum Discussion
Total using SUMX() and calculated table is not correct
In the filter these is no join with
SumByClaim[ClaimNumber],
SumByClaim[ClaimantID]
Is it by design. You should take them in group by and also have max measure of SumByClaim[ClaimNumber],SumByClaim[ClaimantID] to join in filter clause as per need. Think that as second table, you need to put join clause to match dates.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Thanks. But sorry, I didn't quite understand what do you mean? Do I need to group by in my FILTER?