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.
I am unable to add filter condition to calculate the avergae age for Male Employee (Active employee) in Visual Card
I have [Gender}, [Age], [Joing Date] and [Left Date] in table 'Sheet1'
and
[Date] in table 'FY'
@amitchandak I checked the file but didnt get any measure to claculate Average age with Filters and with active employees.
@BhaveshSavla , Check the age measure in this file can help
User | Count |
---|---|
49 | |
40 | |
18 | |
14 | |
13 |
User | Count |
---|---|
100 | |
55 | |
28 | |
18 | |
13 |