You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@Chalfie
So....dax
I have a measure that calculates the percentage of a value. And it's calculated by sum of number / denominator.
Because of relationships, this is dynamic and spits out percentages for different categories from a look up table.
So you can say
:
% of people who are xyz and have had this
I can display what the max of this measure is using maxx and summarize.
What I want to do is show the type of peopl (the xyz).
Do I need to create a dynamic table and then do a lookup value based on max of the measure? That seems like a painful way to do it .
How do I return the xyz with the max and min %?
If I've written
Maxx(summarize (table, people, measure-%))
How do I swap that to return people?
I bet that's clear as mud?