Forum Discussion
ELW
Advocate II
Advocate IIMeasures Partially Responsive to Map Lasso Select
I have a dashboard with locations on a map and a table showing market share (i.e. sum of Sales for one Company divided by sum of Sales for all Companies), plus some other filters and things. A simpl...
ELW,
Try this measure. It uses ALLSELECTED which uses the filter context from outside the visual.
Market Share = DIVIDE ( SUM ( 'Sample Data'[Sales] ), CALCULATE ( SUM ( 'Sample Data'[Sales] ), ALLSELECTED ( 'Sample Data' ) ) )
DataInsights
Super User
Super UserELW,
Try this measure. It uses ALLSELECTED which uses the filter context from outside the visual.
Market Share =
DIVIDE (
SUM ( 'Sample Data'[Sales] ),
CALCULATE ( SUM ( 'Sample Data'[Sales] ), ALLSELECTED ( 'Sample Data' ) )
)