How do i set this formula right?

[GAPER]

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. 

[GAPER]

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 · Accepted solution]

@GAPER 

you can try this

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

[GAPER]

tHIS IS AMAZING

[GAPER]

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. 

[ryan_mayu]

@GAPER 

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

[GAPER]

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]

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

[GAPER]

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]

is this what you want?

what's your current output?

[GAPER]

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

[GAPER]

This one works. May I have your powerbi settings?

Mine is like 

Asia	Toy
Hong Kong	Toy
China	Computer
Korea	Toy
Japan	Computer
Taiwan	PS4

Because Asia is pulling first for the product column. 

[ryan_mayu]

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

hierarchy

[GAPER]

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]

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