Ignore Filter on Visual

[skorpionaa]

I'm trying to ignore master Filter on this measure can anybody help me out

I'm not talking about edit Interaction. I'm talking about the filter on the page. How can I ignore it?

Here is my measure:

alhumaydani% =

var _sales=

CALCULATE(COUNT('ROUND 2 Survey Productivity Data'[row.__created.1]),

'ROUND 2 Survey Productivity Data'[row.username] = "alhumaydani")/COUNT('ROUND 2 Survey Productivity Data'[row.username])

return

IF(ISBLANK(_sales),0,_sales)

This should be 24% but it's giving me 100%.

[ranbeermakin]

Hi there!

You are forgetting ALL or ALLSELECTED in the denominator.

And use DIVIDE function pls.

Ranbeer

[skorpionaa]

Im new here will you give me measure .. bcz i dont know where i ned to add

[ranbeermakin · Accepted solution]

hey, try this

CALCULATE (
COUNT ( 'ROUND 2 Survey Productivity Data'[row.__created.1] ),
'ROUND 2 Survey Productivity Data'[row.username] = "alhumaydani"
)
/ CALCULATE (
COUNT ( 'ROUND 2 Survey Productivity Data'[row.username] ),
ALL ( 'ROUND 2 Survey Productivity Data'[row.username] )
)