Forum Discussion
volt26
Helper I
1 year agoDAX formula that returns columns based on subcolumn's value from smallest to highest
Hello! I need to return columns but the data needed varies on a subcolumn named KEY. Each EVENT can have multiple KEY entries. If KEY is the lowest of EVENT, the formula needs to take the data fr...
- 1 year ago
Hi,
PBI file attached.
Hope this helps.
rajendraongole1
Super User
1 year agovolt26
Helper I
1 year agoWow that is very impressive!
Unfortunately, I get this error in my real file :
It works well when I select one single EVENT but when I select multiple ones, it doesn't.
The demo file provided doesn't return the SUM of all the EVENTS either.
Do you think it is possible to add this feature? I've never been closer to my goal before you gave me this!
I wonder if the formula has to be in the table instead of in a measure?