Divide function not displaying or working with slicers

[Anonymous]

Hi, 

I have two data sets looking at prevelance which already have prevelance figure, which works when you use slicers, but when no slicer is active it displays the below, which is incorrect. 

However when you filter down using the type and location it displays correctly: 

I want to create a divide measure which will replace the column for me which will divide Register column by List Size and work work if no slicers are present and if they are. 
I tried the following: 

GP Prev (%) = DIVIDE(
SUM('GPTables'[List size]),
SUM('GPTables'[Register])
,0
)
Which displays a figure which doesn't add up at all: 

Can anyone provoide assistance? thank you!

[NickolajJessen · Accepted solution]

Hi @Anonymous,

The figure makes sense:
13222 / 485 = 27.26 (2726%)

Can you share the measure for Prevalence (%)?
and Data model?

[Anonymous]

Hi Nickola, 

I'm an idiot and I figured it out! I just had the denominator and numerator the wrong way around. I didn't notice until you said it makes sense ahah!