Problem with displaying correct calculated measure values in column charts

[love]

Hello all.

File with dummy data: https://www.dropbox.com/s/f6gnlzorq6tri9z/MockUp.pbix?dl=0

User story: "AllocatedSelected" in the top left table is a calculated measure that returns a specific value for the selected time range in the date slicer - the value being hours of work. I want to be able to sum this value up for each configuration and visualize those values in a column chart.

Current behavior: If a configuration exists more than once, the value displayed in the column chart is 0 (you can test this by using the "Tasks" filter which as a consequence will only leave 1 value per configuration - it works fine then but not if a configuration has more than 1 value).

Expected behavior: If a configuration exists more than once than the sum of those values is displayed in the column chart. Example: If the "AllocatedSelected" value for Configuration A in Task 1 is 50 and the value for Configuration A in Task 2 is 25 then I would expect the column chart to return me a column for Configuration A with the value of 75.

Thanks,

-L

[love]

@Zubair_Muhammad: You helped me already when I was in the process of creating some related measures in a previous thread.  

Would you please be so kind to have a look and potentially support me with my new challenge here? 

[Zubair_Muhammad · Accepted solution]

Hi @love

Try this MEASURE

Measure =
SUMX ( ALLSELECTED ( Tasks[Task] ), [AllocatedSelected] )

[Zubair_Muhammad]

@love

Please see attached file here

[love]

Looks great! Thank you @Zubair_Muhammad for your support, as always. Much appreciated ❤️

I am not at my work station currently and want to give this solution a try with my actual data set. I will set this thread as completed right when I was able to confirm that.

Thanks again!