Manipulate the Total

[M_SBS_6]

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
22.               Existing.             Flat 22.               Existing.             Flat

So, I have 3 records, 1 distict AppID.

My Row = AppID
Column = AppGroup
Value = count distinct AppID

This is what is returned below.

AppType.   House.     Flat.   Total
Rem.               1.            1.         1

Everything is correct based on the logic however, I'd like the Total to show as a 2 instead of a 1.

AppType.   House.     Flat.   Total
Rem.               1.            1.         2

Is there anyway of doing this please, maybe like a grouping perhaps?

[Daniel29195]

@M_SBS_6 

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! 🤠