Forum Discussion

julesdude's avatar
julesdude
Icon for Post Partisan rankPost Partisan
4 years ago
Solved

Pie 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...
DAX
Need Help
Pie Chart
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    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.

julesdude's avatar
julesdude
Icon for Post Partisan rankPost Partisan
4 years ago

TheoC thank you I am very grateful for your help.

 

I think your solution might be difficult to implement for added DAX columns because in my example I did simplify things somewhat into one table. Technically I have two tables at work here (although they do have a relationship) which are joined by asset reference:

So if we are going to go the add column using DAX route, it might need to be modified?

Like you, I was thinking there could be a cleaner way of achieving this, but I'm happy to go with whatever works if the extra columns route is easier. 

Any help appreciated.

TheoC's avatar
TheoC
Icon for Community Champion rankCommunity Champion
4 years ago

julesdude apologies! I hit Accept Solution instead of Reply. I will provide you a solution shortly!