Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
lt79_Pax
Helper II
Helper II

CalculateTable Embedded In CalculateTable Error

Dear Power BI Representative,
I have a calculated table that was somehow embedded in another calculated table as a summation and causing an error and when I try to delete the summation it will not give me the option to do so.  How do I delete the embedded calculated table?  It also will not give me the option to delete it in the outer calculated column table output.  Please advise.

Thank you.

2 REPLIES 2
amitchandak
Super User
Super User

@lt79_Pax , The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.


Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hi Amitchandak,
I have a calculated table, that I was studying in Power BI entitled:

FilterFabrikamHighMarginProducts =
FILTER (
FILTER (
'Product',
'Product'[Unit Price] > 'Product'[Unit Cost] *3
),
'Product'[Brand] = "Fabrikam"
)

Then I created another calculated table entitled that I was studying as well:
RedProductsCALCULATETABLE =
CALCULATETABLE (
ADDCOLUMNS(
VALUES ( 'Product'[Color] ),
"Num of Products", COUNTROWS ( 'Product' )
),
'Product'[Color] = "Red"

Some how the output of RedProductsCALCULATETABLE seen as sum symbol RedProductsCALCULATETABLE ended up being embedded and contained in FilterFabrikamHighMarginProducts calculated table
and now the calculated table is giving the error message of 'This expression refers to a Column object named 'Product[RedProductsCALCULATETABLE]', which has an error.' In addition the application will not let me delete the sum symbol RedProductsCALCULATETABLE contained within the FilterFabrikamHighMarginProducts calculated table and I do not know how to fix this issue and that is why I am reaching out for help. Please advise. Thank you.
FilterFabrikamHighMarginProducts =
FILTER (
FILTER (
'Product',
'Product'[Unit Price] > 'Product'[Unit Cost] *3
),
'Product'[Brand] = "Fabrikam"
)
! This expression refers to a Column object named 'Product[RedProductsCALCULATETABLE]', which has an error.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! It's time to submit your entry.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.