cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Re: Identify duplicates and show up records

Do you have any nulls (or blanks) on any rows for the column LAK_NUM?

If you do, you might want to add an IF statement into your Variable to check for blanks and use a 0 value in its place.  Something like

 

LAK_NUM = IF (ISBLANK([LAK_NUM]), 0, [LAK_NUM]


   

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

Proud to be a Datanaut!


   


gtamir Member
Member

Re: Identify duplicates and show up records

There are no blanks in the column. 

Why it says there in no current raw?

Super User
Super User

Re: Identify duplicates and show up records

Without seeing your dataset that would be difficult to say.  Generally i'd check things like:

 

  • Did i spell the column name correctly?
  • Is the column in this specific table, and not another table
  • Is there a single blank row in my table
  • Is there a null or blank value in any of my rows for that column

 

From the data area of Power BI, you can copy the table and paste into Excel.  I find that helps with the trouble shooting.  Follow the data and it should start to come clear what is out of the ordinary.


   

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

Proud to be a Datanaut!


   


fbaird Frequent Visitor
Frequent Visitor

Re: Identify duplicates and show up records

Hi Guys,

I couldn't get this to work for me. When I created my expressions based on my data

Count [#"HAWB/HBL"] =
Var HAWB/HBL = [#"HAWB/HBL"]
RETURN

CALCULATE(COUNTROWS('Your Table'),
    all('Your Table'),
    'Your Table'[#"HAWB/HBL"] = 'HAWB/HBL')

The syntax error seems to pick on "var "hawb/hbl". I have tried without parethatsise as well and get the same issue.

 

Please can you help