Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Mapping Stores

Hi, I have a file that has store site information that I want to map. I have an issue with how to display these in a map for the following reason.   Every store site is a "Test Site" AND that Test ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Anonymous I fixed it like this:

    Promo1 = 
ADDCOLUMNS(
    UNION(
        SUMMARIZE('Promo',[Test Site],"Control Site",[Test Site],"Test Cluster",MAX('Promo'[Test Cluster]),"Control Cluster",MAX('Promo'[Control Cluster])),
        'Promo'
    ),
    "Legend",IF([Test Site] = [Control Site],"Test","Control")
)

     

    Updated PBIX is attached below sig.

  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Anonymous Technically it is not. The problem is that the numbers are very close to one another so Power BI is color coding them nearly the same. This is the problem I was referring to. Try this:

    Promo2 = ADDCOLUMNS( UNION( SUMMARIZE('Promo',[Test Site],"Control Site",[Test Site],"Test Cluster",MAX('Promo'[Test Cluster]),"Control Cluster",MAX('Promo'[Control Cluster])), 'Promo' ), "Legend",IF([Test Site] = [Control Site],2^[Test Cluster],2^[Control Cluster]) )

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Greg_Deckler 

 

I will work with this.....but it doesn't need to be ARGIS map. I can use any of the mapping options.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

If you need any help with ArcGIS, drop a line and myself or one of the developer will help out.