Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 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
    5 months ago

    Please try the measure below:

    % of Total =
DIVIDE(
    SUM('YourTable'[Amount]),
    CALCULATE(
        SUM('YourTable'[Amount]),
        ALLSELECTED('YourTable')
    )
)
cengizhanarslan's avatar
cengizhanarslan
Super User
5 months ago

Please try the measure below:

% of Total =
DIVIDE(
    SUM('YourTable'[Amount]),
    CALCULATE(
        SUM('YourTable'[Amount]),
        ALLSELECTED('YourTable')
    )
)
Anonymous's avatar
Anonymous
Not applicable
5 months ago

I need to create two tables to get calculation of value and %, how we can get one table instead of multiple.

this is example my tables contains huge dataset like region/country/state and etc..

 

example

Measure 1 = SUM(Table[amount]

 

Measure 2 = 

% of Total =
DIVIDE(
    SUM('YourTable'[Amount]),
    CALCULATE(
        SUM('YourTable'[Amount]),
        ALLSELECTED('YourTable')
    )
)