Count how many employees whose salary increased

[Anonymous]

Hi,

Date	Emp ID	Salary
01/01/2022	101	1000
01/01/2022	102	1500
01/01/2022	103	2000
01/02/2022	101	5000
01/02/2022	102	1500
01/02/2022	103	3000

As you can see from the table above, Employees 101 and 103 have a salary increase. I'd like a measure for a card visual that counts the number of employees who have a salary increase in comparison to the previous month. In this case, the answer will be just 2.

I appreciate your help.

Thanks in advance.

[pratyashasamal · Accepted solution]

Hi @Anonymous ,
Please create these measures first ,

Measure Last Month = CALCULATE( [Increase count],PREVIOUSMONTH('Table (3)'[Date]))

Measure1 % difference from Salary =

VAR __BASELINE_VALUE = SUM('Table (3)'[Salary])

VAR __VALUE_TO_COMPARE = CALCULATE( SUM('Table (3)'[Salary]),PREVIOUSMONTH('Table (3)'[Date]))

RETURN

    IF(

        NOT ISBLANK(__VALUE_TO_COMPARE),

        DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE)

    )

Count Measure = 1

Increase count = If( [Salary % difference from Measure1] > 0 , [Count Measure]+1,0)
Use a KPI visual

Now could add "Increase count" in  value , "Date" in Trend axis and "Measure Last month" in Target.

Thanks ,
Pratyasha 
Please mark this as the solution if this is helpful for you .

[Anonymous]

Hi, appreciate if anyone could help. Thanks