Problem with measurement and filters

[Syndicate_Admin]

Good afternoon

I have a problem with page filters and measurements.

If in the filter I put "All", it considers me the total of the total, that is, 100%:

But when I select the user "Administrator", it tells me that there are fewer Opportunities, but the percentage is still at 100%:

Instead of 100%, the percentage of the total would have to come out, that is, the percentage that the 86 suppose on the 884 ...

The formula for the percentage measure is this:

RATIO Opp Ganadas =

WHERE _Total = CALCULATE ([COUNT Up Ganadas], ALL(opportunity[opportunityid]))

RETURN

DIVIDE([COUNT Up Ganadas], _Total)

Can you help me, please?

Thank you very much in advance and greetings!

[jdbuchanan71 · Accepted solution]

It looks like there are maybe other filters that are flowing into your meaure that is limiting it.  Try it like this.

RATIO Opp Ganadas =
VAR _Total = CALCULATE ([COUNT Up Ganadas], ALL(opportunity))
RETURN
DIVIDE([COUNT Up Ganadas], _Total)