Forum Discussion

sraj's avatar
sraj
Icon for Responsive Resident rankResponsive Resident
6 years ago

balance with condition

Balance = SUM(vendorDTLPAY2_view[Amount (LCY)]) - SUM(vendorDTLPO2_view[Amount])​ Trying to add a condition to the measure above.  Need this field "vendorDTLPAY2_VIEW[AMOUNT (LCY)]" to pick only v...
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi sraj 

try

Balance = CALCULATE(SUM(vendorDTLPAY2_view[Amount (LCY)]),vendorDTLPAY2_view[Amount (LCY)]<0) - SUM(vendorDTLPO2_view[Amount])​

 

do not hesitate to give a kudo to useful posts and mark solutions as solution

  • sraj's avatar
    sraj
    Icon for Responsive Resident rankResponsive Resident
    6 years ago

    Hi AZ38,

     

    Thanks for responding!! 

     

    I seeing this message "TO USE SPECIAL CHARACTERS IN A MEASURE NAME, ENCLOSE THE ENTIRE NAME IN BRACKETS ([]) AND ADD A ] TO ANY CLOSING BRACKETS IN THE NAME" , I am trying to copy and paste what you have but it just giving me this message....am I missing something?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago
      Instead of copy paste try to write measure by yourself so that you will not miss any syntax or parenthesis.

      Thanks
      Pravin
      • sraj's avatar
        sraj
        Icon for Responsive Resident rankResponsive Resident
        6 years ago

         

        Yes, that's what i did and its working now...but the calcualtion is wrong.  This is what i am getting:

         

        Amount (LCY) = ($276405.42)

        Amount = $271555.14

        Balance = -547961

         
    • az38's avatar
      az38
      Icon for Community Champion rankCommunity Champion
      6 years ago

      sraj 

      are you sure, you write down the sentence correct?

       

      do not hesitate to give a kudo to useful posts and mark solutions as solution