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.
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]))
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
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.
