Calculate percentage of subcolumn

[Anonymous]

Hi Guys

I am trying to calculate the % of the subtotal instead of overall. 

In the example below, SA Found_Own_Employment flag of N or Y should show the % of total SA, instead of grand total. 

Is there a way to solve this? 

[Anonymous · Accepted solution]

Hi Guys. I've actually found a solution. The formula for % of parent total is 

% = DIVIDE( SUM(Placements[Column 2]), CALCULATE(SUM(Placements[Column 2]), ALL(Placements[Found_Own_Employment_Flag]))).

Thanks for your help @Jihwan_Kim @amitchandak 

[Jihwan_Kim]

Hi, @Anonymous 
Please correct me if I wrongly understood.

If you are using ALL function like,

ALL (Table),

then, please try to replace something like, 

ALL (Table[StreamType])

I hope it helps.

Thanks.

Jihwan Kim

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

[Anonymous]

Hi @Jihwan_Kim thanks for the message. Can you please specify the whole formula. I am actually after % of parent total

[Jihwan_Kim]

Hi, @Anonymous 

Sorry, I cannot know the whole formula by seeing the visualization only.

Could you please share your formula, with hiding some of the important information if there is any?

Then, I can try to amend it.

Jihwan Kim

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

[amitchandak]

@Anonymous , You can try like. If need , you can have additional removefilter

divide([measure], calculate([measure], removefilters(Table, Table[Stream Type])))

[Anonymous]

hi @amitchandak thanks for the message. Can you please specify the whole formula. I am actually after % of parent total