Forum Discussion
Sum repeating rows as one (DAX)
Hi, I'm new to Power BI and I want to ask about the DAX formula. So what I want to do is create bucketing for YearOfService, for example 0-2Years -> 100employees 3-5Years -> 30employees etc.. ...
Are you calculating these as columns in a table? if so you should really try to calculate this as measures instead.
Hi sdjensen, Eric_Zhang I can't use measure because actually I also want to create a bar chart like this
If I create it using measure, it can only be put in VALUE field instead of AXIS.
Also, when I create using measure, it only works well if I select 1 employeeID.
It shows both as 13+ Years instead of 9-11 & 13+ (what I want)