cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mohammed Member
Member

different count of records

Hi Every one,


I have report with  table visual,  I try to run the query  in the data source with  the same filter  in the visual filter, but the  number of  records is diffrent 

how  I can solve this issue?

 

 

Note: I reflect all filter  in where  condition  but the  data  in power  bi  missing one  record 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: different count of records

Hi @mohammed ,

 

Did you enable the option "Show items with no data" in your table visual?

 

Capture.PNG

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 REPLIES 5
mnayar Established Member
Established Member

Re: different count of records

@mohammed  can you share the data?

 

 

Community Support Team
Community Support Team

Re: different count of records

Hi @mohammed ,

 

How did you filter the data? Could you please share the screen of  difference?  Kindly share your sample data and excepted result to me. Please upload your files to One Drive and share the link here.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
mohammed Member
Member

Re: different count of records

I find  the Problem, but  I can't Solve It

the  problem in Null Value In my database and  I filter data baed on  col2 = col3 show true if  not show false  like the below table,  but  the first  recorde not show buecose  null value, how  I can  solve  it 

 

 

  

col1col2col3col4
a12nullFALSE
b1111TRUE
c33TRUE
d77TRUE
f1010TRUE

 

Community Support Team
Community Support Team

Re: different count of records

Hi @mohammed ,

 

Did you enable the option "Show items with no data" in your table visual?

 

Capture.PNG

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: different count of records

Hi @mohammed ,

 

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

 

Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.