cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tulsi
Helper I
Helper I

Generalized Formula

Hi,

I have to calculate accuracy which in my case is ((Actual Rounds- Expected Rounds)/(Actual Rounds))-1. I have a column for actual Rounds. The way I calculate Expected Rounds is I multiply it with the number of jobs*TierRound. This TierRound is also a column that exists in my table.Number of jobs I calculate by using count(Job Number) . Can anybody help me with this?

 

 

3 REPLIES 3
PattemManohar
Community Champion
Community Champion

@tulsi Please provide sample data and expected output.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Capture.PNG

The table looks like this. I have created a measure for Total jobs= count(Job Number). I have to get Rounds accuracy, so the accuracy for 4 tiers will be different. Expected Rounds is Total jobs*Rounds. I tried to create a calculated column but there's an error saying there's a circular dependency.

For example if Tier 2 has 20 jobs then expected rounds= 20*2

Tier 3 has 40 jobs then expected rounds=40*3

Tier 4 has 60 jobs then expected rounds= 60*4.

 

You can ignore the tier Round column. For tier 1 expected round count is 1, tier 2 is 2 tier 3 is 3 and tier 4 is 4.

To get expected rounds we have to mulitply number of jobs in that tier * expected round count.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors