Forum Discussion
Average with Limited Value
Hi, I need to be able to visualize the percentage of meeting a goal of the various departments of the company over the months.
The problem is that there are some difficulties, below are the rul...
Hi areias_br
Thanks for reaching out to us.
This looks like it should be the data in the matrix and appears to be the calculated data. Can you provide a .pbix file containing the raw uncomputed data? And please provide the formula how to calculate it, when a person reached the goal or exceeded it, formula=100%; when he did not reach it, formula= ? (need examples according to sample data)
Thanks.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.