Forum Discussion
Ignoring Negative Values in Calculated Column
Hi There, I am trying to create a calculated meaure where i am going subtraction from two columns which contains values as below : I need the result value which is showing in green(2) howe...
Anonymous , of those, are column
sumx(table, if([Total Ask]-[Total Actual]>0 ,[Total Ask]-[Total Actual], blank()) )
Hi Anonymous ,
Please check the formula.
measure1 = SUM('Table'[ask])-SUM('Table'[actual]) Measure2 = IF([measure1]<0,0,[measure1]) Measure3 = IF(ISINSCOPE('Table'[ask]),[measure1],SUMX(ALL('Table'),[Measure2]))Best Regards,
Jay
Hi Anonymous ,
Please check the formula.
measure1 = SUM('Table'[ask])-SUM('Table'[actual])
Measure2 = IF([measure1]<0,0,[measure1])
Measure3 = IF(ISINSCOPE('Table'[ask]),[measure1],SUMX(ALL('Table'),[Measure2]))
Best Regards,
Jay