Forum Discussion
ChirSidh
Helper II
Helper IIUnique Filter with threeway matching - New Column
My data set has a Category (Project Number), Sub Category (Work order number), Close Status ( True/False). One project has many work orders, what i would like to filter is If all the work orders of ...
ChirSidhHelper II
Helper IIHi vanessafvg yes it would be good if the result is limited to first row of project number rest of the rows for the particular project should be empty
Also, can you please look at my other post as well, where i mentioned that I have used this formula in my dataset which is very large, i dont know for some strange reason each row is getting repeated 176 times, am i doing any mistake here?
1 Result =
2 var Project = SELECTEDVALUE(PFT[ Project])
3 var Result = CALCULATE(max(PFT[ Project]),ALLEXCEPT('PFT',PFT[ Project]), PFT[Close?]= FALSE())
4 Return Result