Forum Discussion
BIlix
Helper II
Helper IINeed Help for a Dax Visual
Hello Community, I have a problem with a Dax Measure. I want to calculate the Costs of a Project. The costs of the Project have a specified Formula. First I will breakdown some Data. I h...
Hi BIlix ,
Not sure, please try:
ProjectCosts =
VAR HourlyCosts = SELECTEDVALUE(Sprint[HourlyCosts])
VAR TotalWorkingHours = SELECTEDVALUE(Sprint[TotalWorkingHours])
VAR TotalAdjustedSP = SUMX(FactTable, LOOKUPVALUE(DimSP[Scaling Factor], DimSP[SPID], FactTable[SPID]) * FactTable[SP])
VAR TotalAdjustedSPAllProjects = CALCULATE(TotalAdjustedSP, ALL(FactTable[ProjectID]))
RETURN
IF(TotalAdjustedSPAllProjects <> 0, (HourlyCosts * TotalAdjustedSP) / TotalAdjustedSPAllProjects * TotalWorkingHours, 0)I hope this is helpful to you! If this doesn't work, please let me know. It would be nice to have some sample data and expected output.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum