Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Using a Measure as a filter in DAX formula

Hi Everyone,   I am trying to use the dynamic output of a measure as a filter in a DAX formula.   I have a funtion that calculates a ranking score based on user input, e.g. when they select a loc...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Anonymous

     

    Try this

     

    Greater Count (Measure) =
VAR myranking = [Ranking Score]
RETURN
    CALCULATE (
        COUNT ( predicted[global_site_id] ),
        FILTER ( predicted, predicted[Score 0_100] > myranking )
    )
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Zubair_Muhammad

 

That makes perfect sense, thanks for taking the time to explain.

 

Take care,

 

Kevin

Anonymous's avatar
Anonymous
Not applicable
7 years ago

aaargh!

 

Thanks for your solution!

 

I had the problem that, my first measure [ACT], done with Sumx, was not considered by my second measure in which i had Sumx and Filter (or even calculate as a try). So a problem of context transition. By the way, this article helped me too: https://blog.enterprisedna.co/2016/08/03/what-is-context-transition-and-why-does-it-matter/

 

The solution then for me was to call the first measure via a variable (var vACT = [ACT]

 

Br, G-