Problem with DistinctCount/Group BY + filter condition

[Anonymous]

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

[Anonymous]

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...

[mh2587]

I didn't get you 

can you please share the screenshot and expected output through pics

[Anonymous]

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 !

[mh2587]

Just create distinct measure on item like below

count = distinctcount(item) 

and place that measure with tittle