Forum Discussion
Optimize Summarize dax expression
Hi rawmeat,
Based on my test, I could ues the max function to get the value.
Are there any other restrictions? If I misunderstand you, please let me know as soon as possible.
Regards,
Daniel He
Thanks for the reply!
Sorry let me explain in detail
Let's say we have the following table in our datasource.
CELL FLOW USER TIMESTAMP ERROR
A A 1 1 100
A A 1 2 125
A A 2 3 150
B A 1 4 200
B B 1 5 250
B B 2 6 300
In our reports the table structure is as follows and we apply "User" as a filter
CELL FLOW ERROR
Our user wants to know the latest error in the current context.
If we select USER 1, we should see
CELL FLOW USER TIMESTAMP ERROR
A A 1 2 125
B A 1 4 200
If we select USER 2,
CELL FLOW USER TIMESTAMP ERROR
A A 2 3 150
B B 2 6 300
If we select all user, we should see
CELL FLOW USER TIMESTAMP ERROR
A A 2 3 150
B A 1 4 200
B B 2 6 300
So in the report the user will see the following results:
CELL FLOW ERROR
A A 150
B A 200
B B 300