Forum Discussion

rickylee's avatar
rickylee
Icon for Helper III rankHelper III
7 years ago
Solved

Filter in calculate( )

Hello, In my table, I have a "Total order billing (include refund)" which is the amount for a transaction. I also have a column "refund" which contains either True or False only. To find out th...
Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    rickylee Please try this, if your "refund" field is Text Data type

     

    Total refund amount = CALCULATE(SUM([Total billing]), Test[Refund]="True")

    If "refund" field is Boolean data type then use 

     

    Total refund amount = CALCULATE([Total billing], Test[Refund]=True())
PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 years ago

rickylee Could you please post sample data for testing your scenario.