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 discount count to have something like this :
A 2
B 2
C 2
D 1
I have tried the following measure that is working fine :
MeasureCount = SUMX(VALUES(Title),CALCULATE(DISTINCTCOUNT(Item]))
But here is the tricky part : I want now to have a visual that only contains :
- MeasureCount > 1
- Item = x
So basically :
A / 2
B / 2
But impossible to do that ==> When I add somewhere a filter on Item = x then the measure is changing and gives = 1 to each row...
Any ideas for my problem ?
Thanks a lot
Romain
4 Replies
Just create distinct measure on item like below
count = distinctcount(item)
and place that measure with tittle
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 !
