Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
Creating a column using below dax where in I am passing measure in else condition
Mark-up=
IF(
RELATED(
'Employees'[Rank Code])
= 2700
&&
RELATED(Employees[Salary($)])<50,
SUMX(Employees,Employees[Salary($)]
)
/
1.15,
DIVIDE(
(
related(
Employees[Salary($)]
)
*
[STD Hrs (%)]
),[Total Charge Hours],0)
)))
Below are the measures which I am passing
STD Hrs (%) = DIVIDE(CALCULATE(SUM(Utilization[STD_HRS]), FILTER(Employees, Employees[Department] <> "ADM" && Employees[EMPL_UNO] <> 585)) , 1957.50)
Total Charge Hours =
CALCULATE(SUM('Time & Billing'[Prod_TIME_HRS]), FILTER(Matters, Matters[MATTER_UNO] <> 138321), FILTER(Employees, Employees[Office] <> "WHL" && Employees[Office] <> "FIRM"))
Hi @rathimd ,
Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Best Regards
Lucien
Please provide sample non-confidential data or a link to a non-confidential PBIX file and a depiction of the expected outcome
Proud to be a Super User!
Paul on Linkedin.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |