Need a filter based on transaction level

Anonymous , You can create a new column like

Switch( True(),
not(isblank([Debit])) && not(isblank([Debit])) , "CR & DR" ,
(isblank([Debit])) && (isblank([Debit])) , "Zero" ,
not(isblank([Debit])) ,"Only CR",
"Only DR"
)

Try this:

Column = 
VAR D = Table [DEBIT]
VAR C = Table [CREDIT]
Return
IF(
C = BLANK() && D <> BLANK() , "ONLY CR" , 
IF( 
D = BLANK() && C <> BLANK() , "ONLY DR" ,
IF( 
C <> BLANK() && D <> BLANK() , "CR & DR" ,
IF( 
D = BLANK() && C = BLANK() , "ZERO" , 
BLANK()
)

Hi, Anonymous 

Please correct me if I wrongly understand your question.

I think you can put filters inside your DAX measure to show CRonly or DRonly, or ALL.

If it is OK with you, please share your sample pbix file, then I can come up with more accurate measures.

Thank you.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.