Add another column for each month sapartely

[sdhn]

Hello All,

I am using Power Bi desktop to develop Dashboards.

I created a Dashbaord based on the following information:

DEPARTMENT	MONTHS	COUNTS	MONTH NUMNER
WATER	FEB	80	2
ELECTRICITY	MAR	2	3
DMV	APR	100	4
GAS	FEB	20	2
WATER	MAR	10	3
ELECTRICITY	APR	5	4
DMV	FEB	60	2
GAS	MAR	5	3
WATER	JAN	2	1
GAS	JAN	5	1
DMV	JAN	30	1

On based of above infomation I created a percentage column as:

Percentage = DIVIDE('TABLE'[COUNT],sum('TABLE'[COUNT]))

It s calculate Total Percentage of each row. I used the total SUM of counts (which includes all months).

Now I want to add another column for each month sapartely.  Please advise.  

Your help wil be appreciated.

Thanks 

[v-deddai1-msft · Accepted solution]

Hi @sdhn ,

Please use the following calculated column:

Percentage =
DIVIDE (
    'TABLE'[COUNT],
    CALCULATE (
        SUM ( 'TABLE'[COUNT] ),
        FILTER ( 'TABLE', 'TABLE'[MONTHS] = EARLIER ( 'TABLE'[MONTHS] ) )
    )
)

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]

@sdhn , Create a measure like this and use with month in visual

Percentage = DIVIDE(sum('TABLE'[COUNT]),calculate(sum('TABLE'[COUNT]), allselected('TABLE')))

or

Percentage = DIVIDE(sum('TABLE'[COUNT]),calculate(sum('TABLE'[COUNT]), all('TABLE')))