Creating a percentage of the total

[nickmarlborough]

I have a field called ID and it is associated across the dashboard. 

One of the associations is to the table called 'Issues' which ties the ID so row by row there are issue categories. For example....

Issues	ID
Category1	1
Category2	1
Category1	2

I then in my sheet have a table which has:

Issue	Distinct ID Count
Category1	1
Category2	2

I want to create a new column which represent the % of total irrespective of the Issue Category, but moves in line with other filters applied.

How do i do that?

[JandreKillianRIC]

Hi @nickmarlborough 

Just add a measure 

Count(Distinct ID) / Count(Total Distinct ID) 

However this will do a division based on the distinct values in a Category vs all Distinct categories. 

You might need to play around with removing / keeping the distinct keyword for the desired results. 

Regards Jandre

[Chanty4u]

Hi 

Try this 

Count(DISTINCT ID) / Sum(TOTAL Count(DISTINCT ID))

[diegozecchini]

Other way:

add new measure and use this expression

=Count(DISTINCT ID) / Count({1<DISTINCT ID>} TOTAL ID)

Issue	Distinct ID Count	% of Total

Category1

1

33.33%

Category2

2

66.67%