The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
This is my sample measure I used for # of terminations
Solved! Go to Solution.
Hi @tebtim19 ,
I created a sample pbix file(see attachment) for you, please check whether that is what you want. Please note that there is no relationship be created between Employees and dates table...
Terminations =
CALCULATE (
DISTINCTCOUNT ( Employees[EmpID] ),
FILTER (
'Employees',
NOT ( ISBLANK ( Employees[TermDate] ) )
&& 'Employees'[TermDate] <= SELECTEDVALUE ( 'Dates'[Date] )
)
)
Best Regards
Hi @tebtim19 ,
I created a sample pbix file(see attachment) for you, please check whether that is what you want. Please note that there is no relationship be created between Employees and dates table...
Terminations =
CALCULATE (
DISTINCTCOUNT ( Employees[EmpID] ),
FILTER (
'Employees',
NOT ( ISBLANK ( Employees[TermDate] ) )
&& 'Employees'[TermDate] <= SELECTEDVALUE ( 'Dates'[Date] )
)
)
Best Regards
@tebtim19 , Try measure like
Terminations =
CALCULATE(COUNT(Employees[EmpID]),USERELATIONSHIP(Employees[TermDate],'Dates'[Date]),Employees[TermDate] <date(5999,12,31))
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
126 | |
107 | |
87 | |
65 | |
60 |
User | Count |
---|---|
258 | |
121 | |
117 | |
100 | |
79 |