Forum Discussion

Icon for Memorable Member rank

Memorable 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

Icon for Memorable Member rank

Memorable Member

5 years ago

This table is just link table , table not available at PQ.

Paul

Icon for Community Champion rank

Community Champion

5 years ago

Try changing the DAX to:

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

admin11
Memorable Member
5 years ago
PaulDBrown
Still getting error
admin11
Memorable 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
  Community 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
    Memorable 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.
    
    https://community.powerbi.com/t5/Desktop/How-to-remove-error-when-loading-raw-data-to-PBI/td-p/1653359
    
    Below link is my PBI sample file :-
    https://www.dropbox.com/s/avpixj0ikeb9bvt/PBT_V2021_303%20Customer%20field%20error.pbix?dl=0
    
    Paul