cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

## Calculate formula by 50% time of another value

I am using a Formula on New Measure;

Using A measure, I calculated percentages of specific work.

E.g.

Design Time = 30%

Procurement Time= 30%

Civil Time = 40%

Total = 100%

Project Duration is 30 Days

Now suppose 50% time of above each work is already consumed.

I Showed this by using a slicer which has 30 days and I put slicer bar on 15 days.

Now When I put Bar on 15 days (Total days are 30) that means 50% of work tome is completed.

I need 2 kinds of results

Design Time:  50% consume out of 100% according to Separate schedule

And

Design Time= 15% consume out of 30% according to whole project schedule

(Result-1) I want to show the design team that your 50% time is already consumed.

(Result-2) And total project weightage of design is 30% out of which 15% is consumed.

And which can be achieved by below formula

Formula = Divide (Nominator, denominator) or Divide (A & B)

Now when I put date slicer on 15 days (50% of total days) the formula should work as below

A = 50% of B Value

B = 100% of B Value

I want to make B as constant and A as 50% then the formula show me result.

How I can achieve this, please give any suggestions

1 ACCEPTED SOLUTION
Community Support

Hi @usmanghani ,

According to your description, I created a table as below：

1.Create a measure called Total to calculate time all item spent. The time spent here is assumed to be 100

``Total = SUM('Project'[Spend])``

2.Create a measure called Percentage to calculate the percentage of time spent on all items.

``Percentage = DIVIDE([Total],CALCULATE([Total],ALL('Project'[Item])))``

3.Create a measure called Consumed to calculate time has been consumed.

``Consumed = [Total] / 100``

4.In report page, when you put slicer Bar on 15 days (Actually on day 16), you can show the design team that your 50% time is already consumed, which is the result-1 you want.

At the same time, you can show total project weightage of design is 30% out of which 15% is consumed, which is the result-2 you want.

Best Regards,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 REPLIES 2
Community Support

Hi @usmanghani ,

According to your description, I created a table as below：

1.Create a measure called Total to calculate time all item spent. The time spent here is assumed to be 100

``Total = SUM('Project'[Spend])``

2.Create a measure called Percentage to calculate the percentage of time spent on all items.

``Percentage = DIVIDE([Total],CALCULATE([Total],ALL('Project'[Item])))``

3.Create a measure called Consumed to calculate time has been consumed.

``Consumed = [Total] / 100``

4.In report page, when you put slicer Bar on 15 days (Actually on day 16), you can show the design team that your 50% time is already consumed, which is the result-1 you want.

At the same time, you can show total project weightage of design is 30% out of which 15% is consumed, which is the result-2 you want.

Best Regards,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helper I

Hi, Can you show tables, relations and measures? If possible share your project to for more details.