Forum Discussion

marpisa's avatar
marpisa
Regular Visitor
5 years ago

Exclude some value to Measure

Hi members   Sorry, I'm a bit rusty on formulas (I'm just getting back into Powerbi after not using it for months).   I have this situation   Table  Projects ProjectName Project Member Ho...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

marpisa , You need common project and memeber dimension and using that you can create measures like

sumX(filter(summarize(Timesheet, Project[ProjectName], Memeber[Project Member], "_1", SUM(Timesheet[WorkedHours]) - Sum(Projects[Hours])),[_1]>0),[_1])