Forum Discussion

Foolke's avatar
Foolke
Helper I
7 years ago
Solved

Calculate colum values in Matrix

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

 

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    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.

4 Replies

  • Ronald123's avatar
    Ronald123
    Resolver III
    7 years ago

    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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    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.