Sum positive values of another measure

[Tito]

Hello everyone,

I would like to write a measure where it calculates the sum of only the positive values of other measure.

Thank you very much for your support.

Best regards
Tito

∆ Sales (positive) = 
VAR SalesPrev = 
CALCULATE([Sum Sales],
    OFFSET(
        -1,
        ALLSELECTED('Table'[Date],'Table'[Product]),
        ORDERBY('Table'[Date]),
        DEFAULT,
        PARTITIONBY('Table'[Product])
    )
)
VAR Sales2 = IF(NOT ISBLANK(SalesPrev), [Sum Sales] - SalesPrev)

RETURN
CALCULATE(
    SUMX(
        'Table',
        IF(Sales2 > 0, Sales2, BLANK())
    ),
    FILTER(
        'Table',Sales2 > 0
    )
)

Rsult

 

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[Tito]

Hi @Ashish_Mathur 

Data:

Rsult:

 

 

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attached.

Hope this helps.

[Tito]

Hi,
Thank you very much for your support, it has helped me a lot.

I need to do some more calculations, could you please help me further. The result should look like the picture below.

Data:

 Result:

 
Best regards
Tito

[Ashish_Mathur]

I have already got the result you wanted.  Replicate the same logic for the other measures as well. 

[Tito]

Hi @Ashish_Mathur ,
Thank you very much. It has worked.

Best regards
Tito

[Ashish_Mathur]

You are welcome.

[Tito]

Hi @Ashish_Mathur 
Can you please show me how to split a .pbix file? Thank you

Best regards

[Tito]

Hi @PijushRoy , 
Can you help me please? 

[Anonymous]

Hi @Tito ,

I tried to get what you mean and I also want to create a .pbix file to satisfy your requirements, but I can not do that. Can you provide me your .pbix file or more details about your problems? 

It seems that [Sum Sales] is a measure, so please tell me more things about it.

Best Regards

Yilong Zhou

[Tito]

Hi @Anonymous ,

Data

Result:

 

[Tito]

Hi @Anonymous 
Can you please show me how to split a .pbix file? Thank you

Best regards