Forum Discussion
Solved
Calculating a percentage from two different visualizations
I am trying to figure out the best way to calculate the winshare from these two tables, meaning finding the percentage of the numbers on the right compared to the numbers on the right. For exa...
Hi Rsanjuan,
In your scenario, you can create a measure with DIVIDE() function like below:
Measure = DIVIDE(SUM(realized[Count of Opportunity Name (realized)]),SUM(bid[Count of Opportunity Name (bid)]))
Then format the measure values as Percentage.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
Hi Rsanjuan,
In your scenario, you can create a measure with DIVIDE() function like below:
Measure = DIVIDE(SUM(realized[Count of Opportunity Name (realized)]),SUM(bid[Count of Opportunity Name (bid)]))
Then format the measure values as Percentage.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
Thank you!