% of 2 columns .. I am missing something

[Anonymous]

I am looking to calculate a backup % success rate ... I followed the below:

So my measure looks like the below and I get the error underneath ... 

 here are the columns:

[v-diye-msft]

Hi @Anonymous 

If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. If not, please kindly elaborate more. thanks!

[harshnathani]

HI @Anonymous ,

Try 

Divide(Sheet1[Backup Failure] , Sheet1 [Backup Success])

Or 

Divide(Max(Sheet1[Backup Failure] ), Max(Sheet1 [Backup Success]))

Regards,

HN

[Anonymous]

Hi @harshnathani 

I tried the below ... 

The correct % when the 2 numbers are done correctly is around 99.57% ... I tried COUNT and it gave me 1.00. 

When I tried:

Divide(Sheet1[Backup Failure] , Sheet1 [Backup Success])

it gave me the error of:

[harshnathani]

Hi @Anonymous ,

Try Sum instead of Count. 

Incase the issue is not resolved, pls share sample Data.

Regards,

Harsh

[Anonymous]

@harshnathani 

I tried SUM and it moved it back to 0.00

Here are the 2 datapoints in those columns ...

[harshnathani]

Hi @Anonymous ,

Create a measure

Div =

Var a = Calculate (Max(sheet1[Backup Success]), Filter (Sheet1, Sheet1 [Type] = "Success"))

Var b =  Calculate (Max(sheet1[Backup Failure]), Filter (Sheet1, Sheet1 [Type] = "Failed"))

Return

Divide(b,a)

Regards

HN

[Anonymous]

@harshnathani 

I used your above code:

Here is the result of it ... 

I switch the Divide(a,b) to Divide(b,a)  just to see what would happen and got 0.00

[harshnathani]

Hi @Anonymous ,

Increase the decimal points.

11/2502 = 0.00440

Change the value from 0 to 4 in the circle above and drop down should have decimal.

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

@harshnathani I formatted the units to get .004 % ... not sure how to show that in percent form though. 

I found this is another post searching ... I dont have those options in my ribbon:

https://community.powerbi.com/t5/image/serverpage/image-id/13676iB2044AB000922EEE/image-size/large?v... 

[harshnathani · Accepted solution]

Hi @Anonymous ,

You have formatted the units to get .004.

Select your measure, the ribon above should pop up.

Else you can use the format measure. 

Measure = Format ([your Measure] , "Percent")

https://dax.guide/format/

Regards,

Harsh Nathani

[Anonymous]

I switch the data up a little to see about making it easier ... put everything on 1 row and then created a calculated column of failure + success ... with hopes of being able to then just divide success into backup total count

However, now it wont find the success or total count columns to make the formula ... I tried adding sheet1 in there, but did not do anyting helpful.

then I tried the above code and updated some to the new column I added .. 

% Success =

Var a = Calculate (Max(sheet1[Backup Success]), Filter (Sheet1, Sheet1 [Type] = "Success"))

Var b = Calculate (Max(Sheet1[Backup Total Count]), Filter (Sheet1, Sheet1 [Type] = "Total"))

Return

Divide(a,b)

... did not return anything