Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How do i set this formula right?

    I have a matrix table    Level 1 is Porfolio and and level 2 is Project_short. There is a column I only want to show (ALL_IN_RATE) when it's at level 2 so i created this formula. Anyone...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    Anonymous 

    you can try this

    Measure 2 = if(ISFILTERED('Table'[Column2]),max('Table'[Column3]),blank())

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Let me rephrase. Please see the attached workbook

 

 

 

I just want the best product column not to show any value for Asia because that wouldn't be meaningful Thanks!

 

ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

Anonymous 

you can try this

Measure 2 = if(ISFILTERED('Table'[Column2]),max('Table'[Column3]),blank())

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    tHIS IS AMAZING