Variance by Period without Date

[FlimSpringfield]

Hi, 

I am relatively new to Power BI and have a dataset similar to the below:

I want to display the period on period changes in each status such that I need a visual which will display the following:

So I know that I need a measure which takes the difference between the counts for the current period and prior period but I cannot work out how to implement this into the Calcuate DAX function. 

I could not find an answer on the forums which did not contain dates but hopefully this has a quick answer and I am struggling a bit.

Thanks

[some_bih · Accepted solution]

Hi @FlimSpringfield please try measure Test as below. I got results as yours, not only for period 3. It could be my typo or your data (not shown everything)

Test =

VAR __max_period=MAX('Table'[Period])

RETURN

COUNT('Table'[ID])-

CALCULATE(

    COUNT('Table'[ID]),

    'Table'[Period]<__max_period

)

Output