Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello everyone,
I have a table with hours of productive, unproductive work hours and the total, here as easy example:
In addition to the total I want to know the percentage of the productive/unproductive hours. So something like this:
Is it possible to solve this in one table and maybe also make the formula dynamic in DAX? Should be something like:
SUM(Total of current column) / SUM(TotalHours)
Thank you and best regards
Solved! Go to Solution.
Hi @selimovd
Create measures
pro% = CALCULATE(SUM(Table1[pro]),ALL(Table1))/CALCULATE(SUM(Table1[total]),ALL(Table1)) unpro% = CALCULATE(SUM(Table1[unpro]),ALL(Table1))/CALCULATE(SUM(Table1[total]),ALL(Table1))
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @selimovd
Create measures
pro% = CALCULATE(SUM(Table1[pro]),ALL(Table1))/CALCULATE(SUM(Table1[total]),ALL(Table1)) unpro% = CALCULATE(SUM(Table1[unpro]),ALL(Table1))/CALCULATE(SUM(Table1[total]),ALL(Table1))
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
88 | |
88 | |
74 | |
68 | |
58 |
User | Count |
---|---|
136 | |
110 | |
91 | |
84 | |
69 |