Forum Discussion
Solved
Need help with Counting distinct occurrences
Hello, I would like to count the number of occurrences of water points either new or rehabilitated and visualize the numbers separately in charts. How do I go about this? Thank you
ValtteriN
Community Champion
Community ChampionHi,
There are multiple ways to do this which all differ based on your specific need.
Here are some examples:
Simple measure = count('Water'[Structure])
Measure with filters:
water =
Filter the visual:
CALCULATE(COUNTX(filter(filter(Water,Water[Type] in {"New","Rehabilated"}),Water[Structure]="Water point"),Water[Structure]))
Filter the visual:
I hope this helps to solve your issue and if it does consider accepting this as a solution and giving it thumbs up!
