Hi Everyone, I’ve table that looks like this:
Period | Project | Actual | Budget
1/1/2018 | ABC | 200k | 0
1/1/2018 | ABC| 0 | 300k
2/1/2018|ABC | 150k| 0
1/1/2018|EFG | 150k| 0
I have measures created for Tot_Actuals = sum(Actuals), Tot_Budget = sum (Budget) and Var = Tot_Actuals-Tot-Budget
I want to create a measure to count the number of projects where Var >0 for all periods to date, how do I do that?