Forum Discussion

powerbiusernew's avatar
powerbiusernew
Regular Visitor
6 years ago
Solved

Need help with substraction within a column

Hi all,    I'm a new user here, require some help. I have a column with the following values. What I would like to do is to substract the total count of "Return" to the total count of "Loan". How d...
Need Help
  • vik0810's avatar
    vik0810
    6 years ago

    A simple way would be following measure:

     

    Measure =
CALCULATE (
    SUM ( table[value] ), table[operation_type_desc (groups)] = "Return"
)
    - 
    CALCULATE ( 
    SUM ( table[value] ), table[operation_type_desc (groups)] = "Loan" 
)

    If your table is filtered with the slicers, you may need to adjust the measure to manipulate filter context.

  • powerbiusernew's avatar
    powerbiusernew
    6 years ago
    vik0810 wrote:

    A simple way would be following measure:

     

    Measure =
CALCULATE (
    SUM ( table[value] ), table[operation_type_desc (groups)] = "Return"
)
    - 
    CALCULATE ( 
    SUM ( table[value] ), table[operation_type_desc (groups)] = "Loan" 
)

    If your table is filtered with the slicers, you may need to adjust the measure to manipulate filter context.

    Awesome! I only needed to make minor adjustment (instead of SUM, I used Count) and it works. Thank you!

     

    Regards

    E

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
6 years ago

Hi powerbiusernew ,

 

Is this problem sloved?
 
If it is sloved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
 
If not, please let me know.
 
Best Regards
Icey