I already got the diagramm, but what is missing is the average value. My dimension is "Projektleiter" and my measure is "Auftragswert", which is the value of a "Projekt". I tried to achieve a structure like seen above with the following formula:
Thanks for the reply, now my graph looks like expected, but the value of the AVG function is too high.
Do you have an idea, what could be the reason? I am wondering myself whether it is necessary to incloude the Count (total Projekt), may there be another possibilty? I believe the mistakes is caused by this part.