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...
  • smitht46's avatar
    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]))