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]) )

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

Anonymous So that I understand this, for the first row, you want to see all of the other rows (stores) that have a Control Cluster of 2?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Greg_Deckler yes and then for every unique store within the Test Site column.

 

I was thinking maybe a slicer for Test Site but then that seems like I restrict the overall map a little too much?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Greg_Deckler I just realized that what I said about a Test Site can be a Control Site is not true! All Test Sites do not show up as Control Sites and No Control Sites show up as a Test site.

       

      Does this make a solution easier? I am still trying to figure this out.

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        5 years ago

        Anonymous Don't need the disconnected slicer then or the Complex selector. You could create a measure like HASONEVALUE('Table'[Control Site]),1,0) and use that for a color?