Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have a dataset that I exported from Excel and I have trying to create some measures. I am trying to create measures to give me the percents so I would have percents for "No Overdue," "<8 Overdue," and "8 or > Overdue." I am having trouble trying to create a measure that would allow me to do this. The numerator for the measure would be each of the columns that I listed, and the denominator would be total employees.
Thank you!
Solved! Go to Solution.
You can use SUM( table[Column Name] ) instead of a measure, it will sum each month individually as long as the month column is placed in the visual.
You can create Measure for % of Overdue like below, and use the same logic for the rest.
% of Overdue = DIVIDE( [Totl Employees], [No Overdue] )
Does it matter if I want to sort this by month, or can I just add the month filter onto this? It also isn't letting me pull the columns into the Measure? Does it only allow you put put your own measures in, or can you put the columns into a new measure?
You can use SUM( table[Column Name] ) instead of a measure, it will sum each month individually as long as the month column is placed in the visual.
Okay, I did that and I got the numbers for each month to display which brings me one step closer. The last step I am trying to do is divide by the total number of employees and display that number as a percent. I tried adding that to what I just did with the Sum(table[column]) but it didn't seem to work.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |