Dax code should only show the latest value in the chart

[Sarvagya]

I want to write a Dax code, which give us the value for the latest data. I have written code, which is giving the latest value for all the three categories, but I only want to see the value for only the latest date i.e. 30th November data (Success = 9400)

I have tried different versions as well...

Yesterday order = calculate(sum('order summary item data'[total]), 'order summary item data'[date] = max('order summary item data'[date])))

I

[Anonymous · Accepted solution]

Hi @Sarvagya ,

Because you do not provide sample data, I create a table for test by my understand

1. below is my test table

2. create a measure with below dax formula

Measure =
VAR max_date =
    MAXX ( ALL ( 'Table' ), [Date] )
VAR cur_date =
    SELECTEDVALUE ( 'Table'[Date] )
RETURN
    IF ( cur_date = max_date, 1, 0 )

3. add a table visual and column visual  with fields

4. add the measure that created befor  to above visual filter pane

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Sarvagya , refer if my blogs can help

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