2 measures, 1 for rank and 1 for % of total with gaps in the data

[DaveCor]

Hi folks, 

I have data that looks like this 

Ref ID	Issue Description
123456	Will not start
123456	No power
123456
123456
789236	Will not start
789236	Missing component
789236
986542
986542	Exterior Damage
986542

I have a Ref table which contains all of the above data and more. I have a dim table referenced from that with the Issues listed, dups & blanks removed. 

What i am looking to do is get a % of the total for the issues columns, so in the example above, "Will not start" would be 40% etc like below as I only want to count once for each ref ID number

Issue Description	% of Total Issues
Will not start	40%
Missing Component	20%
No power	20%
Exterior Damage	20%

I am also trying to do a separate measure to allow for ranking of this data. 

Appreciate any help with this as I'm failing miserably at getting this to work. 

[VijayP · Accepted solution]

Create A measure DistinctCount(SomeID) and then in the Table visual you can drag the Measure Twice and convert one field to % to Total using Show Value as option.

[DaveCor]

Wow

I already have that measure and did a quick test and that works exactly the way I want

As the saying goes, soemtimes you can't see the wood for the trees, sheesh

Cheers VijayP