Forum Discussion

Karolina_Sliwa's avatar
Karolina_Sliwa
Frequent Visitor
2 years ago
Solved

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 i...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

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

     

Karolina_Sliwa's avatar
Karolina_Sliwa
Frequent Visitor
2 years ago

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