different count of records

[Anonymous]

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 

[v-frfei-msft]

Hi @Anonymous ,

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

[Anonymous]

@Anonymous  can you share the data?

[Anonymous]

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 

col1	col2	col3	col4
a	12	null	FALSE
b	11	11	TRUE
c	3	3	TRUE
d	7	7	TRUE
f	10	10	TRUE

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

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

Regards,

Frank

[v-frfei-msft]

Hi @Anonymous ,

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

Regards,
Frank