Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 months ago
Solved

DAX Formula

  I have created PBI summarized table and I need another column DAX Formula column grant total divided by rows total NOT Sum of amount (later will add multiple columns)   like 5 /43 , 31/43 , 7/4...
Need Help
  • cengizhanarslan's avatar
    cengizhanarslan
    8 months ago

    Please try the measure below:

    % of Total =
DIVIDE(
    SUM('YourTable'[Amount]),
    CALCULATE(
        SUM('YourTable'[Amount]),
        ALLSELECTED('YourTable')
    )
)
rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
8 months ago

Hii Anonymous 

 

You need row value ÷ overall grand total (dynamic). Create a measure, not a column:

% of Grand Total =
DIVIDE(
    SUM('Table'[Amount]),
    CALCULATE(
        SUM('Table'[Amount]),
        ALL('Table')
    )
)

This keeps the row context (China, International, USCAN) but removes filters to get full grand total (43).