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'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. 

 

 

ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

is this what you want?

what's your current output?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    This one works. May I have your powerbi settings?

     

    Mine is like 

     

    AsiaToy
    Hong KongToy
    ChinaComputer
    KoreaToy
    JapanComputer
    TaiwanPS4

     

    Because Asia is pulling first for the product column. 

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      2 years ago

      you need to separate Asia and other countries to different columns. Then you can have the geo 

      hierarchy

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        They are now in different columns and different hiarachy. But how do you make them to expand like you G1 G2. Mine is expanded vertically 

         

         

        Thanks

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Could you show what would happen if you only showing at asia level (i.e., collapse one level)