Forum Discussion
Different Distinct count
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.
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!
