issue: Finding columns Percentage based on the probability column

[Anonymous]

Hi all, I have 10 data columns. I am trying to find each column Percentage based on Probability column in my dataset to rate my columns in bar chart. Here is the snapshot my data columns:

can anyone please help ?

Thank in advanced

-Ahmad

[v-qiuyu-msft]

Hi @Anonymous, 

The Probability column is not available in your screenshot. If you would like to calculate the percentage when each column divided by Probability column, you can create each measure like below: 

For col1, the measure is: Measure1 =DIVIDE(SUM([col1]),SUM([Probability]))

Best Regards,
Qiuyun Yu

[Anonymous]

Thank you  @v-qiuyu-msft for your response.

As I am following your measure in my problem for col1 , I am not getting the desire result in measure column. 

I also have string columns like col4, col5, col6, col7, col8.

How can i possibly calculate the percentage of my string columns based on my probability column?

can you please guide me on this?

Thanks

Regards,

Ahmad

[v-qiuyu-msft]

Hi @Anonymous, 

>>How can i possibly calculate the percentage of my string columns based on my probability column?

Could you please clarify the desired result? Take the first row as an example, col1 is 45.00, Probablity is 0.26, which value of measure is expected? 

Best Regards,
Qiuyun Yu