Forum Discussion
Power Bi remove duplicated values by itself!
Hi
I have excel table like this
I got data and then tried to insert Table Visual in Power BI. But my table in power bi is not showing the duplicated value (I select do not summerize)
1) Is that by design?
2) if you want t count number of duplicated values, how you would do that?
3) What is the difference between disctinct and distinctcount?
Thank you so much.
Hi lastnn30 ,
1) That is vby design, the values are aggregated by same values, depending on the additional details you had the values get shown.
2) If you want to count the duplicates you can do one of two things:
- Add the column again to your table and select the aggregation Count
- Create a measure with a Count or countrows and use it on the visualization
3) Distinct returns a one column table that contains the distinct (unique) values in a column, for a column argument, be aware that this is a table function and cannot be used has the final result of a measure
DistinctCount Counts the number of distinct values in a column, this can be used has a measure.
In the example you give the Distinct count for each of the values presented would be 6 for the overal table and 1 for each of the values, because it's based on context.
1 Reply
Hi lastnn30 ,
1) That is vby design, the values are aggregated by same values, depending on the additional details you had the values get shown.
2) If you want to count the duplicates you can do one of two things:
- Add the column again to your table and select the aggregation Count
- Create a measure with a Count or countrows and use it on the visualization
3) Distinct returns a one column table that contains the distinct (unique) values in a column, for a column argument, be aware that this is a table function and cannot be used has the final result of a measure
DistinctCount Counts the number of distinct values in a column, this can be used has a measure.
In the example you give the Distinct count for each of the values presented would be 6 for the overal table and 1 for each of the values, because it's based on context.