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 so much for your time helping me on this.

And....it works perfectly for sub total values in the table.

The only issue now is that these are not reflected in the Grand Total, which is a problem because it is this total I'll need to be showing in the table I'm creating and the pie chart:

Can Grand Totals like this reference just the visible counterparts in the table? Is it even possible in Power BI?

 

Thanks again for all your help with this.