Excluding value if not in both quarter

[Anonymous]

Thank you Amit ! 
Works perfectly.

[amitchandak · Accepted solution]

@Anonymous, try like

Sumx(Summarize(Table, Table[Factory], Table[Manfucturing]), if(not(isblank([This Qtr])) && not(isblank([Last Qtr]))  , [This qtr], blank()) )

You need measure like Customer Retention

https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/ba-p/1361529
Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retention/ba-p/1377458