View My Drafts
The values of the same measure seems to be different, when the parameters of the visuals are different.
The data come from a table in Project Online. It is resource demands day by day. I have several lines for each day because of many projects and many resources
I calculate the sum of values day by day and take the maximum of this sum on the period of a month in that case. I have calculated this with several DAX formulas. For exemple :
ResourceDemand Dailypeak 2 =
Then I use a line and stacked column chart without any column legend. The maximum of the column is correct.
In another visual I use a line and stacked column chart with Project Name in the column legend. The maximum is bigger.
In the second visual it takes the maximum of the sum project by project.
Could you help me to have the correct values with Project Name in column legend ?
Thank you in advance for your help