Total is not working

[VIPINGARG]

My total calculation is not working in below example:

Data:

Shee1:

ID	CHANNEL
1	A
2	A
3	A
5	A
6	A
7	A
1	B
2	B
4	B
6	B
7	B
1	C
2	C
3	C
7	C

Table:

Value

1

2

3

pls find below screenshot of power bi measure and attribute

I need some of rows in total.

@PowerBI 

[Ritaf1983]

Hi @VIPINGARG .
In order to achieve a correct count, you need to take two measures:
1.counterID = DISTINCTCOUNT('Table'[CHANNEL])
2. TotallDistinct = if(HASONEFILTER('Table'[ID]),[counterID],

sumx(distinct('Table'[ID]),[counterID]))

Link to sample file 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VIPINGARG]

Thank you for your reply. I frorgot to tell one thing here. I am trying to calculate here is that one ID is coming in how many distinct channel. As I have Max 3 channels here, I can get 1 or 2 or 3 count. Means How many IDs are coming in only one channel and How many IDs are coming two channel and how many IDs are coming in three channels.

[Ritaf1983]

That's fine, my formula does exactly that.
Please note that ID 1 in my table has duplicate channels.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.