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.

PVO3's avatar
PVO3
Impactful Individual
3 years ago

Very hard to understand.

I'm guessing you're looking for something like

DIVIDE(

   SUM(Column),

   CALCULATE(SUM(Column),ALLSELECTED('Table'[Claim type]))

)

  • 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.