Forum Discussion
Different Distinct count
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
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.
2 Replies
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.
Thank you!
