Forum Discussion
jimrosser
Helper III
Helper IIIMap Sales by Region Total for Legend
Hi - looking to add sales amounts to a filled map by region legend. Trying to create a heatmap of sorts by Region. Not having any luck being able to create a measure called Sales Value by Region. I'm looking to divide the US into 5 regions but want the value for each region to remain on it's own without applying any filters.
Any help is appreciated.
jimrosser , Based on what I got
calculate([Measure], allexcept(Geo, Geo[Region]) )
or
calculate([Measure], filter(all(Geo), Geo[Region] = max(Geo[Region]) ) )
1 Reply
- amitchandak
Super User
jimrosser , Based on what I got
calculate([Measure], allexcept(Geo, Geo[Region]) )
or
calculate([Measure], filter(all(Geo), Geo[Region] = max(Geo[Region]) ) )