How i can calculate the percent of "type" of each month in power bi?

[ajguzman]

Hi, how i can calculate the percent of "type" of each month in power bi?¿Quick measure?

NAME	TYPE	MONTH	YEAR
Andy	C	3	2019
Michael	A	3	2019
Diana	B	3	2019
Luis	A	3	2019
Yasme	B	3	2019
Kati	C	3	2019
Rafa	A	3	2019
Yuli	B	3	2019
Ange	A	3	2019
Andy	A	4	2019
Michael	A	4	2019
Diana	A	4	2019
Luis	B	4	2019
Yasme	B	4	2019
Kati	B	4	2019
Rafa	C	4	2019
Yuli	C	4	2019
Ange	C	4	2019
Weyman	A	4	2019

Graphic Example:

	month
	3	4
A	44%	40%
B	33%	30%
C	22%	30%

in a power bi stacked column chart

[Anonymous · Accepted solution]

You can use this measure:

Measure = 
DIVIDE( 
    COUNTROWS(Table2),
    CALCULATE( 
        COUNTROWS( Table2 ), 
        ALLEXCEPT(Table2, Table2[MONTH])
    )
)

which produces this matrix and the associated bar chart:

[MikeJohnsonZA]

Hi

Assuming you are just counting the number of items in the table the calculation could look something like this.

[% of Month Total]=DIVIDE(COUNTROWS('Table1') , CALCULATE(COUNTROWS('Table1'),all(Table1[Type])))

This is the result I got

# I did it in Power Pivot but it is the same for Power BI