Bowtie chart changes Distinctcount output

[torchesamuel]

This is very Weird but I have a distinctcount formula that works well in the tables but the moment i select the Bowtie chart to display this, it changes the numbers kinda counts it.

In the table everything is perfect and even on some other visualiations

[amitchandak · Accepted solution]

@torchesamuel , Are you using a measure like distinctcount(Table[Column]) , if not try that