Different Distinct count

[adityavighne]

Hi,

Any idea  when i see colum in transform data view disstinct count is showing different number than

when i go to table view it show different count?

note:

I haven;t applied any filters

in tranform dat i'm checking for entire data set not just for first 1000 rows

regards,

Aditya

[rajendraongole1 · Accepted solution]

Hi @adityavighne -The distinct count you're seeing in this view (Power query view) reflects the dataset before any relationships, measures, or additional transformations applied in the Data View.

Data view or Table view: After the data has been loaded into Power BI, further modeling or filtering, such as relationships, row-level security, or calculated columns, can affect how the data is displayed and counted. The Table View reflects the dataset after the model is processed, so any modifications made after the Power Query transformations will affect the distinct count here.

Make sure there are no unintended filters or relationships in the Data View that could be affecting the distinct count.

Hope this information helps.

[adityavighne]

Thank you!