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 has an idea why this doesnt' work?/ Thanks.

Anonymous you can try this Measure 2 = if(ISFILTERED('Table'[Column2]),max('Table'[Column3]),blank())

How do i set this formula right? | Microsoft Fabric Community

ryan_mayu
Super User
2 years ago
Anonymous

That's a column. you need to add aggregate function like sum, max ,min.
- Anonymous
  Not applicable
  2 years ago
  So what should I do to get my desired output
  
  For example,
  
  I have three columns.
  
  Level 1 Groupping
  Level 2 Groupping
  Column storying information of the prodocut category of Level 2 (which is not applicable to level 1)
  - ryan_mayu
    Super User
    2 years ago
    not clear about that. Could you pls provide some sample data and expected output?
Anonymous
Not applicable
2 years ago
Basically i don't want to column ALL in rate to show anything when i am at this level. because the data is not meaningful.
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
  Super User
  2 years ago
  Anonymous
  
  you can try this
  
  Measure 2 = if(ISFILTERED('Table'[Column2]),max('Table'[Column3]),blank())
  - Anonymous
    Not applicable
    2 years ago
    tHIS IS AMAZING