Calculate Percentage Based on Type

[Nusc]

HI there,

I would like to sum Time by Type and get the percentage based on a number 5, and if there are more persons in a particular Type:

say nancy and Judy, divide by 5*2 ( nancy + judy) to get the percentage.

ie. for a columb chart:

3/10 for Type A

7/5 for Type B

3/10 for Type C.

[Zubair_Muhammad · Accepted solution]

@Nusc

Try this MEASURE

Measure = sum(Table1[Time])/(5*DISTINCTCOUNT(Table1[Person]))