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

Alomejor — Wed, 08 Mar 2023 12:06:43 GMT

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

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

Anonymous — Mon, 13 Mar 2023 02:35:57 GMT

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

topic Re: DAX meassure that assigns the same value from a category to a subcategory in DAX Commands and Tips

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

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