Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
Solved! Go to 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")
Regards,
Harsh Nathani
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!
HI @Anonymous ,
Try
Divide(Sheet1[Backup Failure] , Sheet1 [Backup Success])
Or
Divide(Max(Sheet1[Backup Failure] ), Max(Sheet1 [Backup Success]))
Regards,
HN
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:
Hi @Anonymous ,
Try Sum instead of Count.
Incase the issue is not resolved, pls share sample Data.
Regards,
Harsh
I tried SUM and it moved it back to 0.00
Here are the 2 datapoints in those columns ...
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
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
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)
@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:
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")
Regards,
Harsh Nathani
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 ..
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |