Forum Discussion

areias_br's avatar
areias_br
Icon for Helper I rankHelper I
4 years ago

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...
Need Help
v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
4 years ago

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.