Forum Discussion

GertWieland's avatar
GertWieland
Regular Visitor
3 years ago
Solved

Flip number sign based on filter context

Hi community, I'm trying flip the plus/minus sign when displaying numbers (i. e. measures) depending on filter context. This is fairly common for financial reporting, and there are likely Power B...
  • DimaMD's avatar
    DimaMD
    3 years ago

    GertWieland  hi, try it 

     

    Measure = ABS( SUM('table'[Amount]) )

Measure 2 = 
CALCULATE( 
    SUM( 'table'[Amount] ),
        ALLSELECTED('table'[TransactionType])
    )

     

DimaMD's avatar
DimaMD
Icon for Solution Sage rankSolution Sage
3 years ago

GertWieland  hi, try it 

 

Measure = ABS( SUM('table'[Amount]) )

Measure 2 = 
CALCULATE( 
    SUM( 'table'[Amount] ),
        ALLSELECTED('table'[TransactionType])
    )