Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Sales Territory as a Dimension - DAX Help! (Nested IF statement?)

My company operates across the U.S.  I would like to align cities with a sales territory so that I can see performance dimensiolanized a different way.   In my dataset I have the cities listed, but...
Need Help
Show and Tell
Tips and Tricks
  • vcastello's avatar
    vcastello
    9 years ago

    Hi Anonymous

    Why don't you just ...

    1.- Create a table in Excel with the list if cities and their classification.

    2.- Import through the Query Editor that table to Power BI.

    3.- Create a relationship between the cities table you just created and the one you have the data in.
    4.- Apply the visual you need.

    Hope That Helps

    Vicente

Anonymous's avatar
Anonymous
Not applicable
9 years ago

sumit4732

 

Sumit, thanks for the speedy advice.

 

I am afraid I would need a little more detail, because I am very much a newbie.

 

My preference would be to use a statement in a column if that was possible?  The only If statements I have used in Power BI, have been binary and have not included this many values.

 

Please let me know your thoughts.  Thanks!

sumit4732's avatar
sumit4732
Icon for Advocate II rankAdvocate II
9 years ago

Hi Anonymous,

 

Firstly, I don't think IF will be efficient here as it only checks one condition, you might have to use SWITCH here.
Secondly, if you have few cities using a switch is fine but when you have a lot of cities I will suggest using a table in place of that and use LOOKUPVALUE function.

 

Hope this helps.

-Sumit