Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Show text in a matrix based on a filter

Hello I'm trying to build a matrix with some information in it. Now I'm stucked in a text filter. I need the matrix to show me differents values depending on the expansion of the first column (Name)...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    Anonymous So maybe this?

    Actions Committed MM3TR&R = 
  IF(
    ISINSCOPE('Table1'[Incidents]),
    [Actions Committed],
      VAR __Table = SUMMARIZE('Table1',[Name],[Incidents],"AC",[Actions Committed],"Per",[Total Percentage])
      VAR __Max = MAXX(__Table,[Per])
    RETURN
      MAXX(FILTER(__Table,[Per] = __Max),[AC])
  )
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Greg_Deckler no! the second screenshot is ok. The problem is in the first screenshot with the column "Actions Commited" because it has to show the string "1/1" because is the string that has the maximum percentage of the column "Total Percentage" (you can see this in the second screenshot).

Here you have another example:

 

General view:

Expanded view:

 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous So maybe this?

Actions Committed MM3TR&R = 
  IF(
    ISINSCOPE('Table1'[Incidents]),
    [Actions Committed],
      VAR __Table = SUMMARIZE('Table1',[Name],[Incidents],"AC",[Actions Committed],"Per",[Total Percentage])
      VAR __Max = MAXX(__Table,[Per])
    RETURN
      MAXX(FILTER(__Table,[Per] = __Max),[AC])
  )
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Greg_Deckler you are a genius!!! it worked! thank you for your patience!!!

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Anonymous Woot!