Sum all positives and all negatives totals dependend on date filter in slicer

[Johannesvd]

Hi all,

It sounds complicated but i think for the pro's a piece of cake. I have a data set where i want to sum the amounts and group them accordingly based on the totals (so not the individual pos / neg rows only totals based on the filter applied in a slicer). i think the measure shoud be something like:

var Temptable : (create temp table with the totals based on the date filter on the report)

var Positives: calculate(sumx [temptable], column result >0)
var Negatives: calculate(sumx [temptable], column result <0)

result

Positives / Negatives

The temptable is the part i want to learn.

IVE MADE IT TO COMPLICATED WITH SOME ALTERATIONS IN THE SOURCE DATABASE I GOT THE DATA, SORRY IF I WASTED  YOUR TIME

[v-jiascu-msft]

Hi @Johannesvd,

I have read this post several times. But how can we get the value 2500? And the 1500 below it.

Best Regards,

Dale