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

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
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