Forum Discussion
Dax Help!!
Anonymous ,
new column =
var _max = maxx(filter(Table, [Account Name] = earlier([Account Name])),[Revenue])
return
if( [Revenue] =_max, [Country],blank())
Hi, Anonymous
Please check the below measure.
Result Measure =
VAR currentaccount =
MAX ( 'Table'[Account Name] )
VAR maxrevbyacount =
GROUPBY (
FILTER ( ALL ( 'Table' ), 'Table'[Account Name] = currentaccount ),
'Table'[Account Name],
"@maxrev", MAXX ( CURRENTGROUP (), 'Table'[Revenue] )
)
RETURN
IF (
SUM ( 'Table'[Revenue] ) = MAXX ( maxrevbyacount, [@maxrev] ),
"Consider this",
"Ignore This"
)
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
hi Jihwan_Kim ,
Thank you for responding so quickly.
I'm looking for the result as below:
| Account Name | Country | Revenue | Country_Result |
| XYZ | Singapore | 1000 | |
| XYZ | Thailand | 800 | |
| XYZ | Vietnam | 900 | |
| XYZ | Sri Lanka | 1200 | Sri Lanka |
| ABC | Singapore | 400 | Singapore |
| DEF | Philippines | 200 | Philippines |
If the the critiria isn't matching, I should get a blank else the Country name.