Forum Discussion

MIkkelHyldig's avatar
MIkkelHyldig
Icon for Helper II rankHelper II
5 years ago
Solved

Filter on calculated measure

Hi  Im using a calculated measure which basically substract to column:  Difference = (SUM(Sales[Posted Sales Amount]) + SUM(Sales[Retail Sales Amount])). The values for Store A can be Posted Sales...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    MIkkelHyldig , Try measure like

     


    Difference =
    var _1= (SUM(Sales[Posted Sales Amount]) + SUM(Sales[Retail Sales Amount]))
    return if(_1 >0 , _1, blank())

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

MIkkelHyldig , Try measure like

 


Difference =
var _1= (SUM(Sales[Posted Sales Amount]) + SUM(Sales[Retail Sales Amount]))
return if(_1 >0 , _1, blank())