Calculating Total of Active Members

[Melissa]

Hi @KieftyKids,

For this type of calculation, you need the “Sales and Orders in Progress” pattern.
Here you’ll find other forum threads dealing with a similar issue and pointing to relevant content here.

Count total number of resources by Financial Year

Hi @tt.xavier welcome to the forum! I’ve created a Date table with a FY year starting on July 1st and Marked that as a date table. [image] Created 2 inactive relationships between the Date table and the tData table. [image] See for more details around this and the limitations, please see: Next Created the following measure: Employee Count = CALCULATE( COUNTROWS ( tData ), FILTER(tData, NOT( tData[Name] ) in {"Vacant"} && tData[StartDate] <= MAX('Date'[Date]) && …

Calculate between time periode

Hi @TrulsB, Welcome to the forum! How to resolve this will all depent on your model, so… It’s important to provide as much context to a question as possible. This includes the data, the model, the formula, the filter context etc. And know that this forum is public. So if your data is considered sensitive - be sure to post a muck-up. Since you have two dates to take into account, I can already suggest looking into this technique.

If you need further assistance please provide a PBIX, thank you.
I hope this is helpful.