Forum Discussion
Solved
Simple DAX expression help?
Relatively new Power BI user here. Working on some DAX language I can't figure out. Scenario is as follows: Patients are seen by doctors at specific encounters. Each encounter has multiple charge...
willit6182 Not 100% sure I understand this. Sample data would help but perhaps something like this:
Column = VAR __ID = [EncounterID] VAR __Codes = SELECTCOLUMNS( FILTER( 'Table 3', [EncounterID] = __ID ), [Procedure Code] ) VAR __MaxRVU = MAXX( FILTER( 'Table 2', [Procedure Code] IN __Codes ), [RVU] ) VAR __Result = MAXX( FILTER( 'Table 2', [Procedure Code] IN __Codes && [RVU] = __RVU ), [Procedure Description (groups) ) RETURN __Result
