Forum Discussion

love's avatar
love
Helper I
8 years ago
Solved

Problem with displaying correct calculated measure values in column charts

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

4 Replies