Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Havinng Clause implement in DAX

select AVG (Salary) ,title from Employee Group By title having AVG(Salary)>25000   this query i would like to implement in DAX measure. not on drag n drop with Average function
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi Anonymous,

     

    Please refer to below formula to create a calculated table:

    Filter Table =
FILTER (
    SUMMARIZE (
        Employee,
        Employee[Title],
        "Average salary", AVERAGE ( Employee[Salary] )
    ),
    [Average salary] > 25000
)

    Regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi Anonymous,

 

Please refer to below formula to create a calculated table:

Filter Table =
FILTER (
    SUMMARIZE (
        Employee,
        Employee[Title],
        "Average salary", AVERAGE ( Employee[Salary] )
    ),
    [Average salary] > 25000
)

Regards,
Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
9 years ago
EVALUATE Filter Table =
FILTER (
    SUMMARIZE (
        Employee,
        Employee[Title],
        "Average salary", AVERAGE ( Employee[Salary] )
    ),
    [Average salary] > 25000
)ORDER BY "Average Salary"

 Can i make use of ORDER BY for this in POWER BI its is not accepting syntax