Forum Discussion
Manipulate the Total
Hi, I am trying to create a matrix which has a distinct count. My data I'm using for this example is this: AppID. AppStatus. AppGroup 22. Existing. House ...
use sumx iterator.
iterate over the column in the visual,
and for the expression, use calculate ( distinctcount( the col you are counting ) )
let me know if this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠