percentage of column grand total

[Anonymous]

i want to calculate % of grand total, for the purpose my 2 measures are as below, the column "primary pct" is showing 100% for all the rows as screemshot below:

primary sum = SUM('Budget Detail'[Sub-Total])
----- 
primary pct = 
VAR CurrentPrimarySum = [primary sum]
VAR AllPrimarySum = 
    CALCULATE(
        [primary sum],
        ALL( 'Budget Detail' )
    )
RETURN
    DIVIDE( CurrentPrimarySum, AllPrimarySum )

while my searching i found the following topic and created formula by @Vvelarde but it is also showing 100%

Topic Link 

% of Grand Total =
DIVIDE (
    SUM ( 'Budget Detail'[Sub-total] ),
    CALCULATE ( SUM ( 'Budget Detail'[Sub-total] ), ALL ( 'Budget Detail' ) )
)

what can be wrong here? please guide to help.

regards

[v-deddai1-msft]

Hi @Anonymous ,

Select the measure and click the %:

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

Best Regards,

Dedmon Dai

[Anonymous]

@v-deddai1-msft 

this is for a Measure, what i asked is different.

when we use for a column/measure in visual and set it to Show value as -> % of grand total it is only showing 2 decimal places, i can't change it.

regards

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

In field formatting, select the %column:

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

Best Regards,

Dedmon Dai

[amitchandak]

@Anonymous , formula is fine, can you share pbix.

[Anonymous]

thanks @amitchandak for your interest to help us, but its not possible for me because of restriction at work.

i have used feature to show value as % of grand total , its working fine but i can't format it as per requirement which shows in screenshot below ( required is in single decimal )

if you can help in this matter i will be much grateful.

regards