% of column total for measure in formula for calculation group

Anonymous — Thu, 25 Aug 2022 21:13:58 GMT

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,

Re: % of column total for measure in formula for calculation group

Anonymous — Mon, 29 Aug 2022 02:51:31 GMT

Hi Anonymous ,

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

topic Re: % of column total for measure in formula for calculation group in DAX Commands and Tips

% of column total for measure in formula for calculation group

Re: % of column total for measure in formula for calculation group