Forum Discussion
Calculating Values is not showing data from latest date
I created a measure where I would liket to calculate with distinct count the number of documents on exact date but it is not showing correct result. What am I doing wrong?
The total I know that is wrong but I have it only for checking what might be not ok:
I should have 86 documents for latest date:
Here is my measure:
Hi Karolina_Sliwa - can you try below measure
Latest Customer Document Measure =VAR LatestDate = MAX('Requirements Data'[Last Available Date])RETURNCALCULATE(MAX('Requirements Data'[Customer Documents]),FILTER(ALL('Requirements Data'),'Requirements Data'[Last Available Date] = LatestDate))it works,
please check
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
3 Replies
- amitchandak
Super User
Karolina_Sliwa , You have the correct sum using summarize or values
Sumx(Summarize(Fact, Fact[Date], Fact[Customer Requirements]) ,[Customer Documents])
Latest Date Date | Latest Data
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0Hmm I did not get, I need to calculate customer documents on latest date and I do not understand why my measure is wrong?
- rajendraongole1
Hi Karolina_Sliwa - can you try below measure
Latest Customer Document Measure =VAR LatestDate = MAX('Requirements Data'[Last Available Date])RETURNCALCULATE(MAX('Requirements Data'[Customer Documents]),FILTER(ALL('Requirements Data'),'Requirements Data'[Last Available Date] = LatestDate))it works,
please check
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
