Forum Discussion

bonjourposte's avatar
bonjourposte
Helper V
2 years ago
Solved

How do I add three variables?

I want monthly totals of how many advances we sent out, and how many collections we took in.   Advances worked fine because there is only one source of money going out.   My measure was fairl...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    2 years ago

    Does this also return a blank?

     

    NumofCollections =
CALCULATE (
    COUNTROWS ( TRANHIST ),
    TRANHIST[TRAN_SUBTYPE] IN { "CORRESP", "PAC", "REGINST" }
)
AlexisOlson's avatar
AlexisOlson
Super User
2 years ago

Does this also return a blank?

 

NumofCollections =
CALCULATE (
    COUNTROWS ( TRANHIST ),
    TRANHIST[TRAN_SUBTYPE] IN { "CORRESP", "PAC", "REGINST" }
)
  • bonjourposte's avatar
    bonjourposte
    Helper V
    2 years ago

    Yes.

     

    I tried it with COUNTX too:

     

    Collections3 =
    CALCULATE (
        COUNTX(TRANHIST,TRANHIST[TRAN_SUBTYPE] ),
        TRANHIST[TRAN_SUBTYPE] IN { "CORRESP", "PAC", "REGINST" }
    )
  • bonjourposte's avatar
    bonjourposte
    Helper V
    2 years ago

    Oh thanks so much!!  I tried what you wrote again and I just removed some filters I had on the side.  Never knew about IN, that is is helpful.  Have a great weekend.