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 i dont have problems with the position I'm in the matrix. I'm having problems with the value I want to show in the matrix in the general view

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

Anonymous So in the second screenshot you only want the Consume alimentos row to show?? If that is the case, you could potentially solve that by doing an SUMMARIZE over ALL where you summarize by your matrix hierarchy elements and include your measure as part of the summarization. Then you would grab the max value from that and compare with your row value and if they are the same, return the % and if not return BLANK. Hard to be super specific without sample data and a clear explanation of what you are trying to achieve.