Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
My measure is and I would like to count only unique ID within it. Where to put that argument?
Headcount =
VAR MinDate = MIN(Calendar[Date])
VAR MaxDate = MAX(Calendar[Date])
VAR result = CALCULATE(
COUNTROWS(
FILTER(
MainTable,
(MainTable[Termination Date-Employment Details] > MinDate || ISBLANK(MainTable[Termination Date-Employment Details])) && MainTable[Hire Date-Employment Details] <= MaxDate
)
),
MainTable[Employee Status] = "A",
)
RETURN
result
Solved! Go to Solution.
@Pbiuserr try:
Headcount =
VAR MinDate = MIN(Calendar[Date])
VAR MaxDate = MAX(Calendar[Date])
VAR result =
CALCULATE(
DISTINCTCOUNT(MainTable[ID]),
KEEPFILTERS(
FILTER(
ALL(MainTable[Termination Date-Employment Details], MainTable[Hire Date-Employment Details] ),
(MainTable[Termination Date-Employment Details] > MinDate || ISBLANK(MainTable[Termination Date-Employment Details])) && MainTable[Hire Date-Employment Details] <= MaxDate
)
),
MainTable[Employee Status] = "A",
)
RETURN
result
@Pbiuserr try:
Headcount =
VAR MinDate = MIN(Calendar[Date])
VAR MaxDate = MAX(Calendar[Date])
VAR result =
CALCULATE(
DISTINCTCOUNT(MainTable[ID]),
KEEPFILTERS(
FILTER(
ALL(MainTable[Termination Date-Employment Details], MainTable[Hire Date-Employment Details] ),
(MainTable[Termination Date-Employment Details] > MinDate || ISBLANK(MainTable[Termination Date-Employment Details])) && MainTable[Hire Date-Employment Details] <= MaxDate
)
),
MainTable[Employee Status] = "A",
)
RETURN
result
Thank you. It works as I can tell!
Perhaps could you help me to do that in this way
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |