Forum Discussion
Terrible at filtering.
So we have a workflow for engineers where they document their time against an opportunity, that once sold gets turned into a project, that they may then again document their time against. I'm trying ...
Ashish_Mathur
Super User
Super UserHi,
You only want to sum up the hours where there is a blank in the Opportunity# column. Try this
=CALCULATE(SUM(Data[Time billed]),FILTER(Data,ISBLANK(Data[Opportunity#])))
Does this work? If not, then share the link from where i can download your PBI file.