Divding two measures where multiple filters come into play

[Anonymous]

The issue is my % is always showing up as 100% so even when i seperated the two measures that make up that % and those numbers are different (it should be 473/679 = 69%), the tile still shows me 100%. The two measures inside of this formula (adoption % will change depending on the selected filters (usually 2 at a time)

Formulas:

Adoption %_m = CALCULATE(DIVIDE([Adoption_numerator],Dynamic_Adoption[Adoption_Dy],"Sorry"))

Adoption_numerator = CALCULATE(DISTINCTCOUNT('Q4 Client list -Fwd Looking'[People Code])) ...*this number will change dependent on which filter i select*

Adoption_DY is a dynamic measure where I can toggle between the the adoption numberator but for different countries. ***this number will change dependent on which filter i select*

[VahidDM]

Hi @Anonymous 

Try these measures:

Adoption %_m = [Adoption_numerator]/[Adoption_Dy]

Adoption_numerator = DISTINCTCOUNT('Q4 Client list -Fwd Looking'[People Code])

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[Anonymous]

The Sorry portion was a joke for myself when it didnt work but I tried the updated formula you mentioned and it didnt work, still gave me that 100%. 

[v-easonf-msft]

Hi, @Anonymous 

You can try accessing the value of [Adoption_numerator] and [Adoption_Dy] using variables.

Adoption %_m =
var a = [Adoption_numerator]
var b = [Adoption_Dy]
RETURN
    DIVIDE ( a, b, "sorry" )

Best Regards,
Community Support Team _ Eason

[Anonymous]

Same result, very interesting. My denominator is a dynamic measure using a switch true statement, could that be it? 

[v-easonf-msft]

Hi, @Anonymous 

We may need more information for further research.

Please share a sample file without sensitive data.

Best Regards,
Community Support Team _ Eason