Forum Discussion

coetseem's avatar
coetseem
Frequent Visitor
1 year ago
Solved

DAX Formula

Hi All,   I have a table with data for teams, the owner / month i am trying to create a formula that determine the % per user per team. I am trying to determine a DAX formula that calculates the Fi...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    coetseem First, calculate the total count per team for the selected month and year:

    DAX
    Total Count by Team =
    CALCULATE(
    SUM('Step 1 - Approval'[Count]),
    ALLEXCEPT('Step 1 - Approval', 'Step 1 - Approval'[Team], 'Step 1 - Approval'[Month])
    )

     

    Then, calculate the percentage contribution of each user per team:

    DAX
    % Contribution by User =
    DIVIDE(
    SUM('Step 1 - Approval'[Count]),
    [Total Count by Team],
    0
    )

bhanu_gautam's avatar
bhanu_gautam
Super User
1 year ago

coetseem First, calculate the total count per team for the selected month and year:

DAX
Total Count by Team =
CALCULATE(
SUM('Step 1 - Approval'[Count]),
ALLEXCEPT('Step 1 - Approval', 'Step 1 - Approval'[Team], 'Step 1 - Approval'[Month])
)

 

Then, calculate the percentage contribution of each user per team:

DAX
% Contribution by User =
DIVIDE(
SUM('Step 1 - Approval'[Count]),
[Total Count by Team],
0
)

  • coetseem's avatar
    coetseem
    Frequent Visitor
    1 year ago

    Thank you, it worked.