Forum Discussion

vijenkin's avatar
vijenkin
Microsoft Employee
5 years ago

IF Table Column Contains Multiple Unique Values use the Highest Index

Based on a solution that came about from a previous thread Solved: Re: IF Table Column Contains Matching Value Place ... - Microsoft Power BI Community, I am trying to solve an unexpected problem aft...
Need Help
vijenkin's avatar
vijenkin
Microsoft Employee
5 years ago

HI Greg_Deckler That was originally the plan I was going with; to use MAXX, however, it doesn't quite work. Is there perhaps a way to modify the DAX code that I have above to essentially in this order:

 

  1. Pull the Unique Code from the Title
  2. Search for the highest Index value if there are multople
  3. Return the Row for the highest index

I suspect no as I would need to pull the Unique Code and use that as a key for the MAXX but I'd thought I'd check. 

 

II've been trying to solve the porblem for the past few hours and it seems no matter how I modify the solution the main crux of the problem is the relationship between Table A and Table B which does need a relationship. Otherwise I wouldn't be able to connect get the Symbolic Name associated with the Unique Code or correlate the Table.A[Unique Code] with the corresponding metric data from Table C, which I know I didn't mention in order to keep things simple. Problem being the Unique Codes in Table B are text values and PowerBi can't build a Many to One relationship.