cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## 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:

1 ACCEPTED SOLUTION
Super User

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,

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Proud to be a Super User!

3 REPLIES 3
Super User

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,

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Proud to be a Super User!

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

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

Frequent Visitor

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors