Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hallo Community,
i have a question about a goal calculation.
I have two Excel tables. One with a AHT (average handling Time and name of a topic) and the other table with goals for the AHT an the topic. (Topic 1 and Topic 2).
I join the tabels like the picture.
The aht measure is sum(aht[cht])/sum(aht[anzahl])
now i take a matrix and set the fields aht und goals
Now I have the problem that I can only calculate an average value for the goals.
What am i doing wrong?
Thanks for help.
Till
Solved! Go to Solution.
Based on the above, you may set cross filter direction to 'Both' in the Edit relationship dialog.
Based on the above, you may set cross filter direction to 'Both' in the Edit relationship dialog.
Thanks, an sorry for the late request.
It works
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |