Forum Discussion
Solved
Employee head Count and Slicers
Hi Everyone, I am new to PowerBI and slowly learning. I have setup sharepoint to house monthly excel files that contain employees for that month. I created a fiscal information table which i...
i think you should not count date. You should distinct count something like employee ID or employee name
so I have a calculated colum called Age group and a column that has ages
the formula is:
Age Groups =
IF ( [Age] <= 19 && [Age] >= 0 , "< 20 Years",
IF ( [Age] <= 29 && [Age] >= 20 , "20 to 29 Years",
IF ( [Age] <= 39 && [Age] >= 30, "30 to 39 Years",
IF ( [Age] <= 49 && [Age] >= 40, "40 to 49 Years",
IF ( [Age] >= 50, "50 > Years",
"")))))
I attached a screenhot of the calculated column with the required information.
To display it, I greated a bar chart and here is the info for that
if I select y-axis to show distinct count it shows 1 count for each age group.
ryan_mayu
Super User
Super Useri think you should not count date. You should distinct count something like employee ID or employee name