Need Help to summing up values with percentage

[Anonymous]

Here Column A (getting Sum of group database value of column 0 or 1 )

Column B (getting Sum of group database value of column 0 or 1 )

So This is How 

Row 1 coming as A=5341 and B=75

Need Help is , I want to get divide this B/A and value should be in percentage 

example = Row 1 value = 75/5341 value should come as 1.4% as for all rows

what ever value of (SUM of B )/(Sum of A) come, its should give me result in Percentage ?

How to do in power baased on value come on Colmn A and B , want to have percentage 

B/A= value 2 decimal point % 

[v-lili6-msft]

hi, @Anonymous 

Just use this formula to create a measure then modeling the format of the value as below:

Result:

Best Regards,

Lin

[Anonymous]

Thanks for reply, But its getting NaN , becuase as said some values in Database are 0 or Some are 1

So In last Column A and B , if we are getting postive results putting as 1 or wise versa as 0

So in Design view, we are jus suming up , so that how it coming Column A and Column B value 

So as we need percentage of it , so in last if we do in when we modeling data , in data sheet we will have all 0 or 1 in last also 

So what i thinking of in run time can we get column C value based on Column A and B outcome ?

[v-lili6-msft]

hi, @Anonymous 

Yes, If you could try this formula to create a measure

Measure = DIVIDE(CALCULATE(SUM('Table'[B])),CALCULATE(SUM('Table'[A])),0)

and if possible, please share your simple sample pbix file and expected output, just from the screenshot, we couldn't find out why result are all NaN.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

Regards,

Lin

[Anonymous]

Basically value i looking from is Derived value that will come from Column A and Column B

Value should like  Column B/  Column A = Answer in Percentage 

Note : I tried Divide Function but fail to achive the result