Dynamic column values in DAX calculation

[selimovd]

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

[v-juanli-msft · Accepted 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.