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 )
    )
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
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 )
    )
dax_powerbi's avatar
dax_powerbi
Frequent Visitor
3 years ago

I am really struggling with this 😞
How can i get this filter to work in a Measure:

sliceGeneric =
VAR m = "BDODEX\AE"
VAR x = "BDODEX\PERF-AE"

RETURN CALCULATE(
    FILTER(systemUsers_A, LEFT(systemUsers_A[DomainName], 9) = m || LEFT(systemUsers_A[DomainName], 14) = x)
)