Calculating Percentage of Unique Count

[Anonymous]

I need help to build a calculation to support the highlighted column.    I need to calculate the total # of options found for a unique count of options.    I need for the highlighted column (below) to divide the Unique Count by the Unique Job.   In this example, the first row should come out to 42.8% (3 divided by 7).    The following represent each of the calculations:

Unique Count = COUNT('options selected'[Option Code])

Unique Jobs = DISTINCTCOUNT('options selected'[Drees Job Number])

Here is my attempt at calculating Unique Job:   % of Unique Job = DIVIDE ( [Unique Count] | 'options selected'[Unique1] )

       Here is what makes up Unique1:       Unique1 = DISTINCTCOUNT('options selected'[Drees Job Number])

As a side note, the last column is working just fine; here is its calculation:

% Of Builder Category = VAR this_Unique =
    SUM ( 'options selected'[Unique] )
VAR group_unique =
    CALCULATE (
        SUM ( 'options selected'[Unique] )|
        ALL ( 'options selected'[Option Code]| 'options selected'[Option Description] )
    )
RETURN
    DIVIDE ( this_unique| group_unique )

[Ashish_Mathur]

Hi,

It is difficult to correct the mistake without looking at your PBI file.  Share the link from where i can download your PBI file.

[Anonymous]

https://www.dropbox.com/s/5l2vdonrrijd3f1/Options%20Selected%20V2.pbix?dl=0

Here you go.

[Ashish_Mathur · Accepted solution]

Hi @Anonymous,

The mistake you committed was that you had created "% of unique jobs" as a calculated column rather than as a measure.  I changed that to a measure.  Furthermore, i computed something called Unique2 and used that as the denominator in your "% of unique jobs" calculation.  I think the subtotal % is still incorrect but i will await your comments on that one.  Here is the file.

[Anonymous]

This is great -- Thanks for your help!!

[Ashish_Mathur]

You are welcome.