SUM headcount by Fiscal Period (non-cumulative)

[Haleem]

I would like to create a measure which SUM headcount column based on user selecting "Fiscal Period" on the Slicer as shown below. When user select P1 and P2, the headcount gets double if i use normal SUM function, as shown below. How can I get the Expected results i.e. The sum should be based on the latest period selected in the slicer i.e. ONLY P2 in the below example, although user has selected P1 and P2. 

[Kristjan76 · Accepted solution]

Hi Haleem,

I would try something like this:

SUM headcount =
VAR lastPeriod = MAX(Table[Fiscal Period])
RETURN
CALCULATE(SUM(Table[Headcount]),Table[Fisical Period] = lastPeriod)

This should work if you have Fiscal Period as numberic value and latest period with highest value. If you do not have a such column, you can just add it as calculated column.

Regards,

kristjan76