Forum Discussion
Problem with DistinctCount/Group BY + filter condition
Hello, I have an issue with a case I have been working on all day 😄 I have a table : Title / Item A / x A / y B / x B / z C / y C / z D / z What I want is to calculate a disco...
But as soon as I do the filter on item = x then the distinctcount is giving me only 1 for each row... Since there is only x as item...
I didn't get you
can you please share the screenshot and expected output through pics
Indeed it will be better with some screenshots.
Initial table :
After the distinctcount group by Title :
The final results in the one below : I want to keep only the title that have distinctcount(index)>1 including index = x (so without Title = C that has only index = {y,z}
But as soon as I apply the item = x filter, then the distinctcount() returns 1 because PBI is only keeping on the main table the following items :
I hope this is more clear !