Forum Discussion
Rsanjuan
Advocate III
Advocate IIICalculating 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
v-qiuyu-msft
Community Support
Community SupportHi 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
RsanjuanThank you!