Getting some measures from Count Distinct

Hey marcss44 ,

you have to create two base measures like so:

M1 = DISTINCTCOUNT(<'table'[column1]>)

 and this

M2 = DISTINCTCOUNT(<'table'[column2]>)

 Based on this you can can create a third measure that divides the measures M1 and M2 rowwise like so:

M3 = DIVIDE( [M1], [M2] )

 And the 4th measure divides the M2 value by the Total value of M1:

M4 = DIVIDE( [M2] , CALCULATE( [M1] , ALL( <'thetableusedonrows'[rowheader] ) ) )

Then you can use all 4 measures in the value well of the Matrix visual.

Hopefully, this helps to tackle your challenge.

Regards,

Tom