PowerBI service table using DAX for calculated column, can't find table error

[buck1327]

I am using Online Service to create a table (by clicking the table icon from Visualizations pane) using semantic data source already there. I am trying to build a table with Column Location (selected from semantic model), then trying to add an calculated column called ColumnA, which use "New Visual Calculation", ColumnA = 

CALCULATE(countx('my table'[column1], [column2]=0)).   'my table' is already there with column1 and column2

but I got error message about not able to find table. Any suggestion?  Thank you for hellp

[v-karpurapud]

Hello @buck1327 

Could you please confirm if your query have been resolved the solution provided by @collinq ? If they have, kindly mark the helpful response and accept it as the solution. This will assist other community members in resolving similar issues more efficiently.

Thank you.

[buck1327]

Thank you. solution provided by @collinq doesn't work for my problem. Appreciate his support and your support

[v-karpurapud · Accepted solution]

Hello @buck1327 

Thank you for contacting the Microsoft Community Forum about the issue with New Visual Calculations in Power BI Service.

The behavior you're encountering is because New Visual Calculations operate differently from traditional calculated columns in the semantic model. Here are key points and solutions to address the issue:

1. New Visual Calculations do not directly access tables in the semantic model as calculated columns do. They work within the context of a visual and may not recognize the table by name.
   
   
2. Some tables might not be available for New Visual Calculations. Please check the Model pane in Power BI to verify the correct table and column names.
   
   
3. In Power BI Service, New Visual Calculations function more like measures than calculated columns. Instead of creating a calculated column, create a measure:

          ColumnA_Measure = CALCULATE(COUNTX('my table', [column2] = 0))

If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.

Thank you!

[buck1327]

@collinq thank you for your help. The table name is exact as the semantic model table name. I am using Online service, not desktop

[collinq]

Hey @buck1327 ,

I think you probalby need to back into the problem then.  Try an extremely easy column first, jsut to be temporary.... like "New Column = [Column1] "  and then try "NewColumn2 = 'my table'[column1] " and see if you get different messages or if that works.

[collinq]

Hi @buck1327 

This is almost always a typo issue.  Can you confirm that you are spelling the table name EXACTLY (copy/paste if you can).  Be sure that there is not space leading or trailing as well and just in case use the same capitalization.  Can you confirm that it is exact?  And, this is in desktop that you are receiving this, right?