Power BI - Get the sum of the Last/Latest Value of a Category/Group

amitchandak — Thu, 14 Jul 2022 17:13:14 GMT

Power BI - Get the sum of the Last/Latest Value of a Category/Group

Problem Statement:

In the given data filter and show only the most recent row based on date/version etc. It should also do the correct sum.

In the last blog, I discussed how can we get the latest status, but it will not give the correct grand total for qty/value.
Data: I have taken data where we have ID and date along with Qty. And we would like to show the latest Qty.

Solution:

We will use a DAX measure for that.

I have loaded the data to the power bi file and created the following DAX measure
DAX Code- I created 2 measures

Last Qty = Var _max = maxx(filter( ALLSELECTED(Data1), Data1[ID] = max(Data1[ID]) ),Data1[Date]) return CALCULATE(sum(Data1[qty]), filter( (Data1), Data1[ID] = max(Data1[ID]) && Data1[Date] =_max)) Sum Last Qty = sumx(VALUES(Data1[ID]) , [Last Qty])

Please check more details on the blog

Re: Power BI - Get the sum of the Last/Latest Value of a Category/Group

LoganH244 — Thu, 20 Jul 2023 12:55:19 GMT

Hello,

I am trying to build a matrix in PowerBI and have created a new measure for my value field:

PSUs = CALCULATE(DISTINCTCOUNT(ARPU[DistinctNumber])) to count distinct values, but the subtotals are not correct with this method.

Do you have any suggestions?

topic Power BI - Get the sum of the Last/Latest Value of a Category/Group in Quick Measures Gallery

Power BI - Get the sum of the Last/Latest Value of a Category/Group

Power BI - Get the sum of the Last/Latest Value of a Category/Group

Problem Statement:

Solution:

Re: Power BI - Get the sum of the Last/Latest Value of a Category/Group