DAX meassure that assigns the same value from a category to a subcategory

[Alomejor]

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

[Anonymous]

Hi @Alomejor,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng