Forum Discussion
Solved
Measures 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' ) ) )
That got it!! Thank you so much!
I need to learn when to use all / allexcept / allselected... I do not understand the nuance.