Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
5 years ago

My Table suddenly display error sign ?

Hi All My customer table suddenly display like error sign , may i know how to remove it ? the system still running fine.   Red triangle  
Need Help
v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi  admin11 ,

 

You are lacking a right-side square brackets in the dax expression:

 

 


Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
5 years ago

v-kelly-msft 

 

Thank you for looking into my post.

i just check the expression is okay , no missing for right bracket  :-

 
Customer = DISTINCT(UNION(ALL(AR[Customer/Vendor Code]), all(SALES[CUST_ID])) )
 
I just open my latest version of PBI which below mark error icon :-
Customer/Vendor Code
 
While i try to delete all table row , and only left with top 8 row. I also notice that thr error sign dis-appear. 
 
This conclude that when my PBI file load in all the data to PBI file , it cause the error appear. 
 
See my post on when loading the data i get a lot of error. in below link.
 
Below link is my PBI sample file :-

https://www.dropbox.com/s/avpixj0ikeb9bvt/PBT_V2021_303%20Customer%20field%20error.pbix?dl=0

 

Paul

 

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi  admin11 ,

     

    Sorry for the late reply,I found that your .pbix file had been deleted,is your issue solved now?If so,could you pls mark the reply as answered to let more people find the solution?

     

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

    • admin11's avatar
      admin11
      Icon for Memorable Member rankMemorable Member
      5 years ago

      v-kelly-msft 

      https://www.dropbox.com/s/3mglp9jcz2fg46h/PBT_V2021_333%20error%20on%20customer%20field.pbix?dl=0

      Above is my PBI file. 

      Pls note that when i delete all the table data , the error will disappear. when i load all the data , the error will appear.

      one thing i seek you hep to advise , it the linking approach correct ? 

      As i suppect that my bridge table for link company and customer_id may be wrong.

      Hope you can advise the right approach.

      Paul

       

      • v-kelly-msft's avatar
        v-kelly-msft
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi  admin11 ,

         

        I didnt see any error in your .pbix file,would you pls check again？

         

        Best Regards,
        Kelly

        Did I answer your question? Mark my post as a solution!