Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Revenue vs Target in Pie Chart

I have 2 tables (Transactions & Target), these 2 tables are related to a date table. When I divide the sum of the [revenue] by the sum of the [target], I get a percentage value for example: 164 / 6...
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi HEZZ, 

    You should know when you put two measure in chart, it will calulate percentage of total value in chart, so you will get 20%(164/(164+630)=20%). So if you want to get correct percentage, you could putthis value in Card or put this value in tooltip in chart to see whether it work or not

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

Hi HEZZ, 

You should know when you put two measure in chart, it will calulate percentage of total value in chart, so you will get 20%(164/(164+630)=20%). So if you want to get correct percentage, you could putthis value in Card or put this value in tooltip in chart to see whether it work or not

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.