HR issue with DAX - first occurence of an employee after filtering
Hello, I have this table with employees. It has a relation with Calendar table. My task is to create a measure that shows new hires first occurances on the date axis (edit: I want to show first occurance of the employee). Now it's just a simple DAX: Hires = DISTINCTCOUNT('Employee'[Name]). So we have such a table in PBI. How to write this DAX so that: - there is only one occurence ( 01/01/2019) when no filter is applied; - when there's a filter Level=Mid there's a new hire an occurence only on 01/01/2019 and when there's a filter Level=Senior there's a new hire one only on 01/01/2021; - when there's a filter Team=Bob there's a new hire only one occurence on 01/08/2021 ? I'm stuck. Please, help.
