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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

this is not working,

it is bringing all the Title even though there is no match.

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

    Thanks Yulugu,

    so can't we write a measure for this instead of calculated table.

  • 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