Percentage of Type

[PPalkowski]

I am trying to create a mesure on a visual that will give me perctange of each type.

Here is the table

I need one visual that show 60% for STANDARD and 40% for NORMAL

Number	TYPE
ID00125	STANDARD
ID00126	NORMAL
ID00127	STANDARD
ID00128	STANDARD
ID00129	STANDARD
ID00130	STANDARD
ID00131	STANDARD
ID00132	NORMAL
ID00133	NORMAL
ID00134	NORMAL

ANy help would be appreciated

[danielkinch · Accepted solution]

Hi @PPalkowski - what type of visual are trying to show this on?

You could create separate measures for each type, e.g.

Standard % =

CALCULATE(COUNTROWS(TABLE), FILTER(TABLE,TABLE[TYPE]="STANDARD")) /

COUNTROWS(TABLE)

Or alternatively, if it's a pie / donut chart then you simply need to drag the TYPE field into the values & legend field.

Hope this helps.

[PPalkowski]

Brilliant!