The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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:
Solved! Go to Solution.
Hi @Karolina_Sliwa - can you try below measure
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!!
Proud to be a Super User! | |
Hi @Karolina_Sliwa - can you try below measure
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!!
Proud to be a 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
Hmm I did not get, I need to calculate customer documents on latest date and I do not understand why my measure is wrong?