Forum Discussion

VIPINGARG's avatar
VIPINGARG
Frequent Visitor
3 years ago

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...
Need Help
Ritaf1983's avatar
Ritaf1983
Super User
3 years ago

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's avatar
VIPINGARG
Frequent Visitor
3 years ago

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's avatar
    Ritaf1983
    Super User
    3 years ago

    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.