Help with measure and allselectec

Question

Hello,&nbsp;If someone can help me with my report I would be very gratefull!I'm looking to create a new measure with total of sales in a matrix filtered by context.&nbsp;I start with my matrix filtered&nbsp; :&nbsp;ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SALESA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;40&nbsp;what I want is :&nbsp;ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SALES&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TOTAL_OF_SALESA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;85B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;85C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;85D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;40&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;85&nbsp;&nbsp;Il I create a measure like TOTAL_OF_SALES = CALCULATE(SUM('TABLE1'[SALES]) ; ALLSELECTED('TABLE2'[ID]) )&nbsp;I have this result :&nbsp;ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SALES&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TOTAL_OF_SALESA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;85X&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 85B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;85C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;85Z&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 85D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;40&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;85Z4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 85Z6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 85&nbsp;Every ID even those which are out of context appear... someidea to avoid this?&nbsp;&nbsp;Thanks.&nbsp;Jerome

anonymous · Accepted Answer

Hello guys,&nbsp;I'm back with a solution...&nbsp;Just need to switch my measure to&nbsp;TOTAL_OF_SALES = SUMX(VALUES('TABLE1'[ID2];CALCULATE(SUM('TABLE1'[SALES]) ; ALLSELECTED('TABLE2'[ID]) )&nbsp;And it works perfectly!&nbsp;sorry for the disturbance.&nbsp;&nbsp;

Forum Discussion

Help with measure and allselectec

1 Reply

Related content

Measure

DAX Measure

Path Measure

% of total measure

Count Measure