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

powerbiusernew's avatar
powerbiusernew
Regular Visitor
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
Community Support
6 years ago

Hi powerbiusernew ,

Glad to hear that. Please accept your solution above so that people who may have the same question can get the solution directly.

 

Best Regards,
Icey