Forum Discussion

ammartino44's avatar
ammartino44
Helper III
9 years ago

Complicated Rule based formula

Hello. This might be complicated.  I have a claims table that is the lookup table and a work table attached. The work order tables has work order number, work order type, work order pricing agreemen...
Need Help
ammartino44's avatar
ammartino44
Helper III
9 years ago

I was able to work this out in the claims table, but this still doesn't help me with the pricing agreement aspect of things. 

 

=CALCULATE(counta(WorkOrder[WO Type]),WorkOrder[WO Type]="Cashout",WorkOrder[Status]="Closed/Completed")

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi ammartino44,

 

You can try to use bleow measure if it works on your side.

 

Count of Specify Rules=
var currType= LastNoBlank(TABLE[Pricing Agreement],[Pricing Agreement])
return
COUNTROWS(
FILTER(
ALL(TABLE),
[Pricing Agreement]=currType&&
OR(
OR([WO Type]="First TIme Dispath",[WO Type]="Cashout")&&[Status]= "closed/completed", 
[WO Type]="Redispath"&&[Status]= "closed/cancelled")))

 

If above is not help, please share me a sample file to test.

 

Regards,

Xiaoxin Sheng