Calculating Values is not showing data from latest date

[Karolina_Sliwa]

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: 

[rajendraongole1 · Accepted solution]

Hi @Karolina_Sliwa - can you try below measure

Latest Customer Document Measure =

VAR LatestDate = MAX('Requirements Data'[Last Available Date])

RETURN

    CALCULATE(

        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!!

[amitchandak]

@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-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee8...

[Karolina_Sliwa]

Hmm I did not get, I need to calculate customer documents on latest date and I do not understand why my measure is wrong?