Remove groups and keep values

Hi AmiraBedh,

Current power bi does not support using measure expressions as category/axis fields to expand other measure calculations. (measure expressions are calculated based on the row contexts so it required a category/group field to define the calculate ranges)

In my opinion, I think you need to use calculate column instead:

Number_of_Employees :=
CALCULATE (
    DISTINCTCOUNT ( HR_Anatlytics[EmployeeSK] ),
    FILTER ( HR_Anatlytics, [DeptID] = EARLIER ( HR_Anatlytics[DeptID] ) )
)

In addition, you can also try to create a new calculated table that used summary records:

NewTable =
SELECTCOLUMNS (
    SUMMARIZE (
        HR_Anatlytics,
        [DeptID],
        "Number_of_Employees", DISTINCTCOUNT ( HR_Anatlytics[EmployeeSK] ),
        "Salary_Expenses", SUM ( HR_Anatlytics[Salary] )
    ),
    "Number_of_Employees", [Number_of_Employees],
    "Salary_Expenses", [Salary_Expenses]
)

If the above formulas do not help, can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us quickly clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng