Forum Discussion

bdehning's avatar
bdehning
Post Prodigy
3 years ago
Solved

Matrix Table Measure Needed

I use a Matrix table and I have numeorus values used to create column of data.   I need help to write a meaure for one of the columns.   I currently have a Field Claim Type and I just used the Fi...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Those are 3 measures.

bdehning's avatar
bdehning
Post Prodigy
3 years ago

Ok here is Table with the Claim Type and the % by Claim Type Column results I want to replicate with a Measure.    I count the occurences of each Claim Type as percent as a percent of the column total.  

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Does this measure work?

Total = countrows(Data)

Total across all claim types = calculate([Total],all(data[Claim type]))

% by claim type = divide([Total],[Total across all claim types])

Hope this helps.

  • bdehning's avatar
    bdehning
    Post Prodigy
    3 years ago

    What is Data in this scenario?    Total is my Count Field and Claim Type is the Column.   

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      3 years ago

      Hi,

      Data is the name of the Table.

      • bdehning's avatar
        bdehning
        Post Prodigy
        3 years ago

        I logically know what I need to do but having a hard time with 

         

        Total = countrows(Data)

        Total across all claim types = calculate([Total],all(data[Claim type]))

        % by claim type = divide([Total],[Total across all claim types])

         

        Is the above One Measure or mulitple?

         

        I aleady calculate Total.