Forum Discussion
Tableau LOD Calculation to Power BI - Text Values
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.
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]))
3 Replies
smitht46 Should just be:
Measure = MAX('Curent User Assignments'[Assigned User Full Name])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.
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]))
