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.
Hi All,
Does anyone know a DAX where I can work out the percentage of jobs complete please?
=(Total Jobs - Open Jobs ) / Total Jobs *100 - Is what i use in excel. I cant seem to figure this out in Power BI as a saved measure.
I have measures for - All Jobs, Open Jobs and Completed Jobs.
Thanks
Solved! Go to Solution.
@Anonymous , Assume you have two measures [Open Jobs], [Total Jobs]
Divide([Open Jobs], [Total Jobs])
Mark this a % column
Thanks both. Neither of these seems to be giving me the correct information.
Hi Bidds10:
Please see attached link. https://drive.google.com/file/d/1u6etqcBzxFg5R4TRCO-qKqhz8UU_sQFv/view?usp=sharing
There is usually more than one way to do this. A lot of measure are built upon other measures, branching out.
I'm using my own made up data but should apply to yours if you change the table name and column names.
You'll see, but the measure for the % complete is:
@Anonymous , Assume you have two measures [Open Jobs], [Total Jobs]
Divide([Open Jobs], [Total Jobs])
Mark this a % column
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |