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.