Forum Discussion
Solved
Sum values from different columns and keep aggregated result
hi I have a simple measure inside 1 table: column A minus column B and it works fine on high level of aggregation. But the problem is that when I add more columns where some rows cont...
Hello RustyD,
You can change the measure like this,pbisup=IF(ISBLANK(SELECTEDVALUE(Tablesil1[B])) ||ISBLANK(SELECTEDVALUE(Tablesil1[P])),0,SUM(Tablesil1[B])-SUM(Tablesil1[P]))
uzuntasgokberk
Super User
Super UserHello RustyD,
You can change the measure like this,
pbisup=
IF(
ISBLANK(SELECTEDVALUE(Tablesil1[B])) ||
ISBLANK(SELECTEDVALUE(Tablesil1[P])),
0,
SUM(Tablesil1[B])-SUM(Tablesil1[P])
)