Forum Discussion
Solved
Measure based on a condition from other table
Hi Community, hoping you can help me with this task. I have this data table tblForecast: Category__________Month_____________Cost Cat1________________Sep_______________100 Cat1_____________...
I believe what you want is something along the lines of:
Measure = CALCULATE(SUM(TblForecast[Cost]),FILTER(RELATEDTABLE(Months),[ForecastOrActuals]="F"))
Let me know if that works. If not, I'll try to recreate your data and test.
Is there a relationship between the two tables?
- Hi Greg_Deckler, yes there is. A one to many relationship.
