Kiwi_Kyle's avatar
Kiwi_Kyle
Regular Visitor
2 years ago
Status:
Accepted

Calculated Table with Calculated Columns; Glitch where creates measure in formula bar

I am having an issue where if I have a calculated table (first 5 columns calculated table) and then calculated columns added to the end (last 4 columns of the table) when I left click from a calculat...
Data Modeling
MAYOD's avatar
MAYOD
Regular Visitor
2 years ago

I am seeing the same issue with Version: 2.126.1261.0 64-bit (February 2024).

 

I can consistantly replicate this in a calculated table. It occurs whenever selecting an entire column in Table View (by clicking on the column header) and then switching to a different column (by clicking on that column's header).

 

For example:

  • Create a single column calculated table from an existing date dimension, using the formula:
    • CalcDate = SUMMARIZE('Dates',[Date])
  • Add a calculated column to table CalcDate:
    • Test = "abc"

Issue can be replicated by clicking on the header for column 'Test' to select that column, then clicking on the header for column 'Date' then clicking back on the column header for column 'Test'. This results in the formula for the calculated column 'Test' being overwritten with the same formula as the 'Date' column i.e. the calculated table formula CalcDate = SUMMARIZE('Dates',[Date]) which then returns #ERROR due to the calculated column returning a table of multiple values.

 

I can also consistantly cause the table formula in the first column to be overwritten with the calculated column's formula by:

  • Selecting a value in one of the data rows for column 'Test'
  • Then selecting the header of the 'Date' column

This is a particularly problematic bug since the change is not able to be undone (short of closing the PBIX file without saving) and can result in the loss of existing logic in calculated columns/tables.

 

I am also seeing behavior where clicking between the headers of multiple existing calculated columns causes an error dialogue 'Rename column: The name <calculated column name> is already used for a column on table <table name>. Chose a different name. It appears likely this is the same issue - PBI is trying to copy the formula (including the name) of one calculated column and paste this into the next selected calculated column, but because the first column name already exists, it fails and displays the name error.

Completed Ideas