Help with Measure

[vjnvinod]

Dear all,

Below is my table visual in power BI desktop.

I am looking for a measure which can calculate the desire count based on multiplying"Target" to "Total of Projected FY21 Closing HC"

for eg

5.50%*1494=82.17 (See below the output table as well)

Target is a coloumn and "Total of Projected FY21 Closing HC" is Measure in my model

Output table

Rank	Projected FY21 Closing HC	Target	Desired Count
Partner/Principal	60	5.50%	82.17
Executive Director	34	11.00%	164.34
Senior Manager	163	3.30%	49.302
Manager	150	16.50%	246.51
Senior	723	33.00%	493.02
Staff/Assistant	364	30.70%	458.658
	1494		1494

[VijayP]

@vjnvinod  you can use this pbix

[vjnvinod]

@VijayP 

thanks for this, this is not helping as well

because Projected FY21 Closing HC is a measure and below is how i have calculated the measure, its calculated using different tables

Projected FY21 Closing HC = [Latest HC]+[Preboarding Pipeline]+[Additional approved Exp Hire]+[Additional Approved Graduate]-[Confirmed Exists]-[Exit Pipeline]

[amitchandak]

@vjnvinod , A new column if [Closing HC Target] is a column

sum(Table[Projected FY21]) * [Closing HC Target]

A new measure if [Closing HC Target] is a measure

calculate(sum(Table[Projected FY21]), all(Table)) * [Closing HC Target]

[vjnvinod]

@amitchandak 

Note Projected FY21 Closing HC is a "Measure"

Projected FY21 Closing HC = [Latest HC]+[Preboarding Pipeline]+[Additional approved Exp Hire]+[Additional Approved Graduate]-[Confirmed Exists]-[Exit Pipeline]

and Target is a coloumn

I am not able to use your solution because Projected FY21 Closing HC is a measure

[vjnvinod]

@amitchandak  @VijayP 

attached is the sanitized pbix file, if it helps

https://drive.google.com/file/d/109YRdkB2STFy4w7DADMqtsJresM5SACs/view?usp=sharing

[vjnvinod]

@amitchandak 

All, let me know if its difficult to achieve, as i am not able to find any solution

https://drive.google.com/file/d/109YRdkB2STFy4w7DADMqtsJresM5SACs/view?usp=sharing

[Anonymous · Accepted solution]

Hi @vjnvinod ,

Sorry for delay. When I click the file URL, I got the error information "Sorry, the file you have requested does not exist.". Could you please share the file again by OneDrive for Business? Thank you.

Share OneDrive files and folders

In addition, please try to create a measure as below and check whether it can work in your scenario or not.

Measure =
VAR _tab =
    ADDCOLUMNS (
        CALCULATETABLE ( VALUES ( 'Table'[Rank] ), ALL ( 'Table'[Rank] ) ),
        "PFY21CHC", [Projected FY21 Closing HC]
    )
VAR _tempHC = [Projected FY21 Closing HC]
RETURN
    SUMX ( FILTER ( _tab, [PFY21CHC] = _tempHC ), [PFY21CHC] ) * [Target]

Best Regards