Ignore page level filter in Measure

[Anonymous]

So, I´m building Sales Reports and need a help. I have 2 tabs, one of opened opportunities and one with closed one. In the closed one tab I have a measure calculating the WinRate, that is basically taking all opportunities closed as Won / by the total of closed opportunities.

Now in the Opened Tab I want to use this meaure to apply on my pipeline in a way that I´ll the have the following (let´s say my WinRate is 35%):

Total Pipele = 1.000.000

Closing Projection (based on the measure) = Total Pipeline * 35%

But when I use my meausre in the Opened tab it comes as blank. This is why this page is filtered by only opened opportunites.

Anyway to achieve what I need?

[MFelix · Accepted solution]

Hi @Anonymous ,

You need to create something like this:

Closing Projection (based on the measure) = [Total Pipeline] * CALCULATE([WinRate];ALL(Table[Column}))

You should replace the Table Column by the ID column on your table or a similar one.

Regards,

MFelix