Forum Discussion
Counting the Most Recent Status
The target is to count the most recent activity status by date. I currently have COUNTROWS of a table and that is correctly giving me all status categorized by dates but there is a new requirement on...
Hi Anonymous ,
please check if that helps you.
Thank you for your support. I was able to figure out a measure to give me the count of the most recent activity with the following:
Store ID Count = COUNTROWS(DataTable)
Most Recent Activity Count =
CALCULATE(
[Store ID Count],
FILTER(
DataTable,
MAX(DataTable[Store_ID])
),
LASTDATE(DataTable[Date])
)
My problem now is that when I drop this information into a matrix table, the individual activities are still visable. Although the count is correct, is there a way for me to not have the individual activities visable?
Your advice is greatly appreciated.
Hi Anonymous ,
can you share some screenshots of the data model and matrix?