Measure of percentage of grand total

[Anonymous]

Hallo,

Could you please help me with a simple measure to calculate the percentage of each fraction, as it in the last column? 

[Ashish_Mathur]

Hi,

Assuming Value is a measure that you have written, try this measure

=[Value]/CALCULATE([Value],ALL(Data[ID]))

Hope this helps.

[v-alq-msft]

Hi, @Anonymous 

Based on my research, you may create a measure as follows.

Result = 
DIVIDE(
    SUM('Table'[Value]),
    CALCULATE(
        SUM('Table'[Value]),
        ALL('Table')
    )
)

or

Result2 = 
SUMX(
    'Table',
    DIVIDE(
        'Table'[Value],
        CALCULATE(
            SUM('Table'[Value]),
            ALL('Table')
        )
    )
)

Then you may make the measure selected, go to 'Modeling' ribbon, click '%' and set 'Decimal places' as 0.

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-alq-msft 

Thank you for your answer.

The only problem I am having is that the value is not responding to the filters. You can see below what I mean. 

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

You may use the following measure.

Result = 
DIVIDE(
    SUM('Table'[Value]),
    CALCULATE(
        SUM('Table'[Value]),
        ALLSELECTED('Table')
    )
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you! 🙂

[amitchandak]

Try like

divide(sum(table[Value]),calculate(sum(table[Value]),all(Table)))

[Greg_Deckler]

The above is for a Table visualization.

If you need a column in a table:

Column = DIVIDE([Value],SUMX('Table',[Value]),0)

[az38]

Hi @Anonymous 

try a measure

Measure = 
DIVIDE( SELECTEDVALUE(Table[Value]),
CALCULATE(SUM(Table[Value]), ALL(Table))
)

or just set parameter "Show value as - Percent of Grand Total" in visual value settings 

[Greg_Deckler]

In the Values area, click the drop down and then Show As and then Percent of ...