On my PowerBI dashboard I do have the measure that presents SUM(REVENUE)/SUM(QUANTITY) ratio. Problem is that data into DB about revenue and quantity does NOT come in the same time. So it could happened that data of quantities come into DB for first three months and data about revenue for two months only. My measure then will present sum of two months revenue divided by sum of quantities from all three months and this does not represent real ratio!

So I need some trick to tell PBI (measure) to SUM only quantities of months where there exists corresponding revenue!