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
PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
5 years ago

admin11 

 

Try changing the DAX to:

Customer = DISTINCT(UNION(DISTINCT(AR[Customer/Vendor Code]), DISTINCT(Sales[Cust_ID)))

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

PaulDBrown 

I think found the issue , when refresh , suddenly i notice i got many error. last time dont have this issue , and yet now all report still okay not affected.

 

  • 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!