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())

ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

Anonymous 

That's a column. you need to add aggregate function like sum, max ,min.

  • Anonymous's avatar
    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's avatar
      ryan_mayu
      Super User
      2 years ago

      not clear about that. Could you pls provide some sample data and expected output?

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Let's consider this. The main goal is that I don't want it to show any aggregration (first/last) for Asia in the product column.