Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello Greg_Deckler  and thank you for your answer!

It seems like a really good answer but I am not quite sure of what data it gets. Is there any modification that I can put in that piece of code to show me a graph (like the one I showed) and how it has been trimmed down? I hope I made sense. I am really new to DAX.

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    Anonymous - Well, to use that measure, you would replace the highlighted portion with your column name and you would need to replace the 'Table' reference with your table name. You would replace the .2 with the percentage of values that you want to trim off (top/bottom %)

     

    TRIMMEAN =
    VAR __Table =
    ADDCOLUMNS(
    'Table',
    "Rank",RANKX('Table',[Value])
    )

    VAR __Percent = .2

     

    After that, you would use this measure instead of what you are currently using in your visual.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thank you Greg_Deckler 

       

      That really helped! I got all the data I needed!