Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Dynamically display image based on measure - DAX help!!!

I have a dashboard which shows salesperson productivity.  I created a measure that compares "Current Rank" with Last Month "Rank" to show movement.  If they gain a position the number is positive, no...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Greg_Deckler

 

Looks like a great solution.  However, my current and last month rank is not a calc.  Thoughts?

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

Hard to say without knowing what your data looks like but if it just some number in a table, just use something like:

 

Measure = IF(MAX([Column])<0, <unichar down arrow>, <unichar up arrow>)

Again, tough to say without knowing what your data looks like.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Greg_Deckler

     

    This is a sample file. 

     

    The only thing not calculated is my measure that compares current and previous written as:

     

    Change = sum(Sheet1[Last Month's Rank])-SUM(Sheet1[Current Rank])

     

    https://www.dropbox.com/s/7n76e5g7bkhqnps/Unichar%20Rank.xlsx?dl=0

     

    Would appreciatre if you can expand on the full DAX statement to address each of the values of Up, Down or "--"

     

    Thanks, this is really helpful.