How to calculate only the positive values?

[Tiitti7]

Hi,

I need some help how to calculate to the right chart only the positive values that are in the left chart.

In the left chart I have used measure = [Expenses] - [BM expenses] and then I can filter the negative values.

But how can I add only these positive values to the right chart? Now it shows the sum of total amount of the measure.

Thank you in advance

[v-stephen-msft · Accepted solution]

Hi @Tiitti7 ,

Please try:

New measure =
SUMX (
    FILTER ( ALLSELECTED ( 'TABLENAME' ), [measure in left chart] > 0 ),
    [measure in left chart]
)

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.                      

[amitchandak]

@Tiitti7 ,

Sumx(filter(Values(Table[X-axis Column]), [measure] >0) , [Measure])