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

     

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
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!!