Tableau LOD Calculation to Power BI - Text Values

[smitht46]

My data source contains entries where each assigned individual comes in as a separate row. For example, if I have one unique ID, but with three different assigned users, the data shows in my report as three separate entries. I only need to capture one assigned user (doesn't matter which one in the order) in the report. 

Currently, in Tableau I am able to accomplish this by using the following formula. 

{ FIXED [ENTRY ID]: MAX([Assigned User Full Name])}

What is the equivalent function in Power BI for text values? I tried the following, but since it seems to look for integer values, it doesn't work for me. 

Remove Assigned To Dups = FIXED('Current User Assignments'[Card ID],MAX('Current User Assignments'[Assigned User Full Name]))

Thanks!

[smitht46 · Accepted solution]

I think I figured it out. The formula I used that appears to be working is: 

= CALCULATE(MAX('Current User Assignments'[Assigned User Full Name]),ALLEXCEPT('Current User Assignments','Current User Assignments'[Card ID]))

[Greg_Deckler]

@smitht46 Should just be:

Measure = MAX('Curent User Assignments'[Assigned User Full Name])

[smitht46]

Thanks @Greg_Deckler . This will just bring in the MAX name from the entire data set and assign that same name to each row of data. I need to also make sure I am assigning each name that is specific to the individual ID.