Hi all.
Im stucked trying to figure out how to get the following:
Imagine i have a country divide my 7 work Areas, i made a meassure to assign a value to each area based on the value obtained by each one, that is, I assign the one with the highest value a 7, the second a 6 and so on.
now, these areas include different numbers of provinces, that is, each area is made up of different provinces, and what I want is to assign to each province that is part of that area the value of the area calculated previously
To assign a value to each area I have written the following measure:
AreaT value = VAR Frequency = RANKX ( ALL ( Fact_Info_Envios[AREA T] ), [Area T Count] ) RETURN 7 - Frequency + 1
But i dont know now how to asiggn that value of each area to the provinces who belong to that area.
any help is wellcome
