What To calculate percentage for Bench count on basis of Los

[bhavadharani]

I have two columns named as

    1.Los

    2.Bench count 

My need is to find the percentage of Bench count on basis of Los:

  For example,

     Here in LOS I have different sectors like  Aws Devops,Krisopia,Data Engineering,etc.. I want to calculate percentage for Bench count based on different sectors of Los. Please help me to solve my problem.

Thanks in Advance  

[HiraNegi · Accepted solution]

Hi @bhavadharani ,

You can create a measure to create bench count % by LOS like below.

Bench% =

SUM(Bench[BenchCoount]) /

CALCULATE(SUM(Bench[BenchCoount]), ALLEXCEPT(Bench,Bench[LOS]))

Hope this helps.

Regards,

Hira Negi

Please don't forget to upvote and Accept as answer if the reply is helpful

[v-jianboli-msft]

Hi @bhavadharani ,

Based on your description, I have created a simple sample:

Please try:

Measure = 
var _a = COUNTX(FILTER(ALL('Table'),'Table'[BENCH_COUNT]=SELECTEDVALUE('Table'[BENCH_COUNT])),[LOS])
var _b = COUNTX('Table',[LOS])
return DIVIDE(_b,_a)

Final output:

Best Regards,

Jianbo Li

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

[SamInogic]

Hi @bhavadharani,

As per our understanding, you need to calculate percentage of "Bench Count" for Distinct LOS sector on the basis of different sectors in your Power BI report.

Create new measure with below DAX expression as shown in below screenshot,

% of Bench count = DIVIDE(SUM('Table'[Bench Count]),CALCULATE(SUM('Table'[Bench

 Count]), not ISBLANK('Table'[Los])))

This will calculate the Percentage of Distinct Sector (LOS Column) as shown in the below screenshot,

If this answer helps, please mark it as Accepted Solution so it would help others to find the solution.

Thanks!

Inogic Professional Service Division

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at crm@inogic.com

Service:  http://www.inogic.com/services/ 

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

[HiraNegi · Accepted solution]

Hi @bhavadharani ,

You can create a measure to create bench count % by LOS like below.

Bench% =

SUM(Bench[BenchCoount]) /

CALCULATE(SUM(Bench[BenchCoount]), ALLEXCEPT(Bench,Bench[LOS]))

Hope this helps.

Regards,

Hira Negi

Please don't forget to upvote and Accept as answer if the reply is helpful

[bhavadharani · Accepted solution]

Thanks a lot @HiraNegi  @SamInogic ,

 The above formula works me for calculating the percentage of bench count, but I want to calculate the percentage based on los. For example, If I select the Los as Azure Devops then I want to calculate the overall percentage of bench count for Azure DevOps alone.

  Kindly help me to solve my problem @HiraNegi @SamInogic 

[HiraNegi]

Hi @bhavadharani ,

I am still unclear on your requirement. Will it be possible to share the sample expected output?

[bhavadharani]

@HiraNegi Thanks a lot, I got the output