Calculate colum values in Matrix

[Foolke]

Hi all,

I have a matrix as in table below.

How can i get an extra column where i Divide created by #Open Tickets (LTM)

Colum created = count

Open Tickets (LTM) = measure

Thx

[Ashish_Mathur · Accepted solution]

Hi,

Ensure that the Created column is a measure - you may use the COUNTA function for that.  Thereafter, write this measure

=[Created]/[# Open Tickets (LTM)]

Hope this helps.

[Foolke]

Thx @Ashish_Mathur , this solved my problem!

[Ashish_Mathur]

You are welcome.

[Ronald123]

Hello @Foolke ,

You ask for a new colum in de the matrix.

First you need to make a new measure with the DAX function DIVIDE. Divide function

Then add this measure to the matrix.

Greets,

Ronald