Matrix Total

[M_SBS_6]

Hi, 

I have a matrix with values but some of my totals don't add up. My value is a distictcount on app_id which is a text. I also have a 1 to 1 join app ID To comp ID. I use the comp table for the row (house_type)

        House.  Flat.   Bungalow 

Rem.  20.        5.          1

Conv. 30.        10.         3

FA.      12.        7.          2

Total  60.         21.       6

Any idea how to get this to Total right please?

[Idrissshatila]

Hello @M_SBS_6 ,

try creating this measure:

measure = countrows( values(YourColumnName))

[M_SBS_6]

Thanks for the suggestion but that gives me the same output as my distinct count. 

[Idrissshatila]

Hello @M_SBS_6 ,

it depends on the measure you're using. Please insert your measure.

[M_SBS_6]

I'm just dragging app_id into the value then on the down arrow, I am selecting Count (distinct)