Forum Discussion

skorpionaa's avatar
skorpionaa
Helper I
6 years ago
Solved

Ignore Filter on Visual

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%.
Interesting Links
Need Help
Show and Tell
Tutorial Requests
  • ranbeermakin's avatar
    ranbeermakin
    6 years ago

    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] )
    )

3 Replies

  • ranbeermakin's avatar
    ranbeermakin
    Resolver III
    6 years ago

    Hi there!

     

    You are forgetting ALL or ALLSELECTED in the denominator.

     

    And use DIVIDE function pls.

     

    Ranbeer

    • skorpionaa's avatar
      skorpionaa
      Helper I
      6 years ago

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

      • ranbeermakin's avatar
        ranbeermakin
        Resolver III
        6 years ago

        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] )
        )