Forum Discussion
Solved
Filter with specific definition
Hi all, I would like to ask you for help with DAX formula for following situation: I have this simple table with 2 columns where is order number and operation number: ORDER OPERATION 111 ...
Hi, Peter_2020
Try to create a measure like this:
Measure = VAR _OR_OP=SUMMARIZE(FILTER(ALL('Table'),'Table'[ORDER]=MAX('Table'[ORDER])),[OPERATION]) VAR _IF= IF( {2} IN _OR_OP&&{4} IN _OR_OP ,1,0 ) RETURN _IFResult:
Please refer to the attachment below for details. Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Peter_2020 , Measure like
Countx(Summarize(Table, Table[Opearation], "_1",calculate(distinctcount(Table[Operation]) , filter(Table, Table[Operation] in {2,4} ))) , if( [_1]=2,1,0) )
amitchandak Thanks for the tip but the result is for all orders the same - value 1....