Guitarmageddon
Board Regular
- Joined
- Dec 22, 2014
- Messages
- 161
Hey Folks,
Not sure how to do this via dax. Of course, we can simply do a MAX formula to give us the max value for a field. But, what if I want to know a corresponding column heading for what the max was. In other words, a text field which "owns" that max.
Here is some survey summary data I have. Still kind of toying with how I present it. Each of the column headings on the pivot table is a measure I made. There is a column in the source data where the user selects a dropdown for "capabilities" which are the options you see in orange. And next to that column is a priority assessment. I made a measure for each to count it, not sure if I even needed to do that but I went ahead. How would I go about writing a measure to give me the text value of the corresponding highest measure? For example, for the orange columns, I would want a measure that returns "INCAPABLE", for the financial management capability. Likewise, "INCAPABLE" for merchant activities capability. Does that make sense? Is there a simpler way to do this? Perhaps it could have been done inside a table with M/power query before I exported.
The measures were built like this just to give you an idea of the scheme
Not sure how to do this via dax. Of course, we can simply do a MAX formula to give us the max value for a field. But, what if I want to know a corresponding column heading for what the max was. In other words, a text field which "owns" that max.
Here is some survey summary data I have. Still kind of toying with how I present it. Each of the column headings on the pivot table is a measure I made. There is a column in the source data where the user selects a dropdown for "capabilities" which are the options you see in orange. And next to that column is a priority assessment. I made a measure for each to count it, not sure if I even needed to do that but I went ahead. How would I go about writing a measure to give me the text value of the corresponding highest measure? For example, for the orange columns, I would want a measure that returns "INCAPABLE", for the financial management capability. Likewise, "INCAPABLE" for merchant activities capability. Does that make sense? Is there a simpler way to do this? Perhaps it could have been done inside a table with M/power query before I exported.
The measures were built like this just to give you an idea of the scheme
