% of column total for measure in formula for calculation group

[Kikemx90]

Hello,

Could you please help me or indicate me if there is a way to get the % of column total for a measure based in calculation group and calculation items for 2 different months as following:

I need a formula to get the same value that % of column total is getting but since it is calculation group I am having a hard time, 

[Anonymous · Accepted solution]

Hi  @Kikemx90 ,

I created some data:

Here are the steps you can follow：

1. Create measure.

Measure 2 =
DIVIDE(
COUNTX(FILTER(ALLSELECTED('Table'),'Table'[CONTR ACCOUNT Period]=MAX('Table'[CONTR ACCOUNT Period])&&'Table'[Group]=MAX('Table'[Group])),[Amount]),
COUNTX(ALL('Table'),[Amount]))

2. Result:

If you need pbix, please click here.

% of column total for measure in formula for calculation group.pbix

If I have misunderstood your meaning, please provide your desired output and your pbix without privacy information.

Best Regards,

Liu Yang

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