Forum Discussion
Mapping Stores
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.
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 I would use a disconnected table for your slicer and then create a Complex Selector to use in the Filter pane for your map. The Complex Selector - Microsoft Power BI Community
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.
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?
I am still having a hard time simply trying to filter to a test site and just see that test site and the control sites that compete with that test site. Something as simple as this is perplexing me. Can I upload my .pbix?
Anonymous Sure.