Forum Discussion

bonjourposte's avatar
bonjourposte
Icon for Helper V rankHelper 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
Icon for Super User rankSuper 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
Icon for Helper V rankHelper 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" }
)