Forum Discussion

Mughees's avatar
Mughees
Helper II
5 years ago
Solved

Making calculated field from matrix columns

Hi All, I have to add alot of calcualted fields in my data set that need to be created from the value columns of the matrix. However, I am unable to do that. I tried to apply some formulas but they ...
Need Help
  • Jimmy801's avatar
    Jimmy801
    5 years ago

    Hello Mughees 

     

    i think you have just do create two measure that counts the rows of your table, filtering one time for adeq on time for inadeq. After that create one more measure to make a calculation of the 2 new created measures.

    Find enclosed the file

     

    Hope this helps

     

    Jimmy

Jimmy801's avatar
Jimmy801
Community Champion
5 years ago

Hello Mughees 

 

i think you have just do create two measure that counts the rows of your table, filtering one time for adeq on time for inadeq. After that create one more measure to make a calculation of the 2 new created measures.

Find enclosed the file

 

Hope this helps

 

Jimmy

Mughees's avatar
Mughees
Helper II
5 years ago

Hi Jimmy,

Unfortunatley it is not working. Can you see my above reply and file I have attached for reference.

  • Jimmy801's avatar
    Jimmy801
    Community Champion
    5 years ago

    Hello Mughees 

     

    did you see my file? To me it seems that's exactly working as your Excel-file. You have to add for sure a slicer for years, and in case fix the date-column somehow in month, that you are able to filter them to. But the main question, how to make the measures was answerd

     

    BR

     

    Jimmy

    • Mughees's avatar
      Mughees
      Helper II
      5 years ago

      Hi Jimmy. Thanks a million. You just gave the right solution. I was out in field work so I could not possibly look into it more deeply.