Forum Discussion

smitht46's avatar
smitht46
Frequent Visitor
3 years ago
Solved

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 a...
Need Help
  • smitht46's avatar
    smitht46
    3 years ago

    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's avatar
Greg_Deckler
Community Champion
3 years ago

smitht46 Should just be:

Measure = MAX('Curent User Assignments'[Assigned User Full Name])
smitht46's avatar
smitht46
Frequent Visitor
3 years ago

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.