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

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

Hi Anonymous,

 

You can enter mapping table for cities to territory and then use lookupvalue function in your existing dataset to get territory as a custom column.

 

Hope this helps.

Let me know if you have any questions on this.

 

-Sumit

  • 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