Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Estimado representante de Power BI,
Tengo una tabla calculada que de alguna manera estaba incrustada en otra tabla calculada como una suma y causando un error y cuando intento eliminar la suma no me dará la opción de hacerlo. ¿Cómo elimino la tabla calculada incrustada? Tampoco me dará la opción de eliminarlo en la salida de la tabla de columnas calculada externa. Por favor, aconséjese.
Gracias.
Solved! Go to Solution.
Hi Amitchandak,
In reviewing the other tables in the model I found the issue. I had the RedProductsCALCULATETABLE contained in the original Product table. When I deleted that one it also removed the others. Thank you for your willingness to help me.
@lt79_Pax , La información que ha proporcionado no está des aclarando el problema para mí. Por favor, puede explicar con un ejemplo.
Apreciamos tus Felicitaciones.
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.
Hi Amitchandak,
In reviewing the other tables in the model I found the issue. I had the RedProductsCALCULATETABLE contained in the original Product table. When I deleted that one it also removed the others. Thank you for your willingness to help me.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
1 |