Forum Discussion
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
- loveHelper I
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? :robothappy:
- Zubair_MuhammadCommunity Champion
- Zubair_MuhammadCommunity Champion