Combining measures from different tables

[Palikaros]

Hello,

I have one table named CV_BPC_BRIDGES_R4_ACT where all actual financial data are flowing, from which i created a measure "

PY Actual Net Sales" which calculates Prior year actual net sales.

I have also one more table CV_BPC_BRIDGES_R4_ACT (since data are flowing from different system) for all Current year + Forecast financial data, where i have created a measure "CY Actual Net Sales".

Is it possible to create a measure that will combine these two measures? Of course, it should be dynamic, as the initial measures based on the user`s selection for quarter & country (this is managed through slicers)

Thank you in advance.

[amitchandak · Accepted solution]

@Palikaros , Not very clear, but you can combine measure(add two measures) across common dimensions

= [Measure1] + [Measure2]

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio... 

[Palikaros]

Thanks @amitchandak , it worked 🙂