Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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.