Dax calculation Filling Null based on ID column
Dax calculation Filling Null based on ID column Real Time Problem: I have a table that has two main columns: Account ID and Customer Name. The Customer Name column contains a lot of blanks but the Account ID field is complete, so I was wondering if there's a way to get PowerBI to recognise that Account ID 1 is used against the Customer Name, and therefore to fill in any blanks as a result of this? I know this is really confusing, here's an example: Name AccountID John 1 John 1 Null 1 John 1 So is there a way to get PowerBI to recognise that EmpName = Account ID 1, therefore any rows that have the Account ID 1 should fill any blank cells in the Customer Name column with EmpName? I want these null cells filled so I can use the Customer Name as a Slicer. Solution: Filled_Name = IF( ISBLANK('YourTabl...