Forum Discussion

stephank's avatar
stephank
Frequent Visitor
8 years ago
Solved

DAX field scoping

The problem is that under 'ProjectMart' Table I can select only previously defined measure and not other colums i.e [Cu Feature Points] that are within the 'ProjectMart' Table. Why is that? and How d...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi stephank,

     

    In addition, the formula(without defining a new measure or variable) below should also work. :smileyhappy:

    EV TEST2 =
COUNTROWS (
    FILTER (
        ALL ( ProjectMart[Cu Feature Points] ),
        ProjectMart[Cu Feature Points] > MAX ( ProjectMart[Cu Feature Points] )
    )
)

    Note: You can replace the MAX function with any other aggregation functions(i.e. MIN or SUM), which should also work.

     

    Regards

popov's avatar
popov
Resolver III
8 years ago

Hello,

Try this formula:

 

EV TEST2 :=
VAR
CurrentSP = MAX(ProjectMart[Cu Feature Points])
RETURN
COUNTROWS (
FILTER (
ALL(ProjectMart[Cu Feauture Points]),
ProjectMart[Cu Feature Points] > CurrentSP
)
)