Cannot Create Measure : Cannot find table

[weiliang_lim]

Hi All,

I am trying to create a simple distinct count on my ID but the measure cannot be created and indicate that the table cannot be found even though I have imported the table. Any idea what is wrong ?

[ankitpatira · Accepted solution]

@weiliang_lim you're getting red line underneath meaning intellisense hasn't found table with syntax you've typed. Perhaps rename table name to something simpler like 'table1' and then reference it using DAX.

[weiliang_lim]

@ankitpatira Thanks, I've changed the naming and it worked perfectly.