Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
i have a table with expected Billable Hour and I'm trying to figure out how many hours each person can contribute.
If they have 2,000 expected hours they need to work 80%, if they have less then 2,000 they need to work their percent of hours.
I have a column that lets me know the expected hours. and the percent of hours if not 2,000.
I created an if measure however it didn't work.
Below is the Chart of data I have.
Solved! Go to Solution.
Is your data types correct? You are comparing text '2000' to integer? Also, we do not see your measure in your matrix where is it being used? How do we know it's not working? Please provide sample data, not an image.
Proud to be a Super User!
Is your data types correct? You are comparing text '2000' to integer? Also, we do not see your measure in your matrix where is it being used? How do we know it's not working? Please provide sample data, not an image.
Proud to be a Super User!
| User | Count |
|---|---|
| 23 | |
| 19 | |
| 18 | |
| 17 | |
| 13 |
| User | Count |
|---|---|
| 60 | |
| 52 | |
| 47 | |
| 40 | |
| 38 |