Hi,
I have a dimension called project. Another calculated field shows the average quality level of each project.
I want to show in a table those projects which have the best average quality level. The best project can be just one project or several project which share the same (best) quality level.
How can I do this?
This statement lists the average quality level:
Avg ({<[Initial Quality Level]-={0}>}[Initial Quality Level])
This statement finds the maximum:
Max(all aggr(Avg ({<[Initial Quality Level]-={0}>}[Initial Quality Level]), [Initial Quality Level]))
And this formula shows in the table for each project whether it has the maximum level or not
Avg ({<[Initial Quality Level]-={0}>}[Initial Quality Level]) = Max(all aggr(Avg ({<[Initial Quality Level]-={0}>}[Initial Quality Level]), [Initial Quality Level]))
But I don't know how I can filter the project dimension with this formula. Any help?