Required DAX For the Exclusive And Common Components

[AnilKumar]

Hi all,

 I have  raw Data like below. Based on my selection (Slicer) , Need to Segregate the Commonly used and  Exclusively Used Components. I Have  Listed only 2 Main Items. in my case 1000s of Items are presented. Please suggest an idea.

Thanks in Advance,

Vishnu Priya.

[v-chuncz-msft]

@AnilKumar 

You may use DISTINCTCOUNT to add a measure.

Measure =
SIGN ( DISTINCTCOUNT ( 'Table'[Main Item] ) - 1 )

[AnilKumar]

Hi,

DistinctCount Will give me the actual MainItmes of that Component. Please see the snap where based on my selection in slicer "Config",  There may be  any number of Main Items. In these mainitems, what i need is, Exclusively used components like in Only 1 mainItme, in 2 MainItems, in 3 MainItems, in 4 MainItems.

I Was unable to filter the visual with exclusive Items and  commonly used in 2/3/4 Main Items.

Thanks ,

Vishnu Priya.