Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

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

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

Community Support
Community Support

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  


Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors