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

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

       

      • ryan_mayu's avatar
        ryan_mayu
        Super User
        2 years ago

        you can try turn off the stepped layout in the matrix settings.