Forum Discussion

Aucesar's avatar
Aucesar
Helper III
3 years ago
Solved

DAX Calculation Help

Hi Community another day, another challenge 🙂   Need to acomplish this calculation...thanks for any help in advance!   Date MainWorker Assistant TotalItens DefectoiTens %Defecto Desired...
Need Help
  • vicky_'s avatar
    vicky_
    3 years ago

    Calculation = 
var helperTable = UNION(
    SELECTCOLUMNS(ALL('Table'), "workers", 'Table'[MainWorker], "defecto", 'Table'[%Defecto]), 
    SELECTCOLUMNS(ALL('Table'), "workers", 'Table'[Assistant], "defecto", 'Table'[%Defecto])
)
return SUMX(FILTER(helperTable, [workers] = SELECTEDVALUE('Table'[MainWorker])), [defecto])

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

In the Query Editor, select all columns other than Main Worked and Assistant, right click and select Unpivot Other columns.  Rename the Atribute column as Employees.  Drag the Employees column to the visual and write this measure

Measure = sum(Data[%Defecto])

Hope this helps.