Percentage calculation

karkarYes! So how you handle this depends on what overall % you'd like to show (and which method you've decided to use)

In your sample you have the following

PAT - Num - Den -  %

1 - 2 - 6 - 33%

2 - 3 - 3 - 100%

So far so good - but now the question is how do you want the Total % to be calculated

(2+3) / (6+3) which is 56% - (if you want this option you have to go with Summary Table 1)

OR

 ( 33%+ 100%) / (distinctcount of patients) which would be 67% - (both options would work)

Hope this makes sense!

So for Summary Table 1 here are your Measures

Percent Measure 1 =
DIVIDE (
    SUM ( 'Summary Table'[Summed Num] ),
    SUM ( 'Summary Table'[Summed Den] ),
    0
)

Percent Measure 1a =
DIVIDE (
    SUM ( 'Summary Table'[Percent] ),
    DISTINCTCOUNT ( 'Summary Table'[PAT] ),
    0
)

And the results...

Hope this helps!

Good Luck! :smileyhappy:

EDIT: If you do want the 67% here's the Measure for Summary Table 2

Percent Measure 2 =
DIVIDE (
    SUM ( 'Summary Table 2'[Percent] ),
    DISTINCTCOUNT ( 'Summary Table 2'[PAT] ),
    0
)

And result...

Good Luck! :smileyhappy: