Forum Discussion
julesdude
Post Partisan
Post PartisanPie Chart Problems - Can't Add Values for Totals Using Last Date Only
Hi there, Edit to my original post as it wasn't clear! I'm having difficulty getting my pie chart to work. I have a source table that's like this: Last Updated Country Asset Reference T...
Hi, julesdude ;
You could create a measure.
total = var _max=CALCULATE(MAX('TableA'[Date]),ALLEXCEPT(TableA,'TableA'[Country])) return CALCULATE(SUM('TableB'[Total Value]),FILTER(TableB,[Date]=_max))The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
julesdudePost Partisan
Post Partisan
