topic Re: FUNCTION IF DOES NOT WORK in DAX Commands and Tips

FUNCTION IF DOES NOT WORK

Anonymous — Wed, 03 May 2023 14:51:18 GMT

Hi,

I'm trying to use a function IF to change the name of the Cities to "Others" if they are not in my Top 15 based on highiest billing but my DAX isn't working.
I don't know if it is important but I also have a column "Year" that I use to filter in the visual.

I created this measure:

TopNCities = RANKX(ALL(BASE_RES_TABLEAU[CITY]),CALCULATE(SUM(BASE_RES_TABLEAU[Billing])))

And then I tried to create this column but is not working:

TopCity = IF([TopNCities] <= 15, BASE_RES_TABLEAU[CITY], "Others")

What I'm doing wrong?

Re: FUNCTION IF DOES NOT WORK

eliasayyy — Wed, 03 May 2023 16:13:10 GMT

You need to use allexcept(table,year) if you are filtering by year

Re: FUNCTION IF DOES NOT WORK

Anonymous — Wed, 03 May 2023 17:37:46 GMT

where do I use allexcept(table,year)?

Re: FUNCTION IF DOES NOT WORK

eliasayyy — Wed, 03 May 2023 17:46:02 GMT

In you rankx function instead of all