Forum Discussion
Total is not working
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.
3 Replies
- Ritaf1983
Super User
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.
- 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.
