Forum Discussion

ChirSidh's avatar
ChirSidh
Icon for Helper II rankHelper II
3 years ago

Unique 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 ...
Need Help
ChirSidh's avatar
ChirSidh
Icon for Helper II rankHelper II
3 years ago

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?

Result =
var project = SELECTEDVALUE(PFT[ Project])
var result = CALCULATE(max(PFT[ Project]), ALLEXCEPT(PFT,PFT[ Project]), PFT[Close?] = "FALSE")
Return result