cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
kunuthuri Member
Member

DAX Expression

HI

 

Can you please assist on below SQL Query to DAX expression. How to write DAX Query.

 

select Employee e.ID

Left Join

project p ON e.ID=p.ProjID

group by e.ID

having sum(p.percentage)<25

 

 

Thanks

Kunuthuri

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: DAX Expression

@kunuthuri

 

May be a calculated table like

 

New Table =
FILTER ( ALL ( Tablel[Id] ), CALCULATE ( SUM ( Table2[Percentage] ) ) < .25 )

or a MEASURE

 

measure =
COUNTROWS (
    FILTER ( ALL ( Tablel[Id] ), CALCULATE ( SUM ( Table2[Percentage] ) ) < .25 )
)
3 REPLIES 3
kunuthuri Member
Member

Re: DAX Expression

Topic : finding how many employees are working in project with below 25 percentage work.

Super User
Super User

Re: DAX Expression

@kunuthuri

 

May be a calculated table like

 

New Table =
FILTER ( ALL ( Tablel[Id] ), CALCULATE ( SUM ( Table2[Percentage] ) ) < .25 )

or a MEASURE

 

measure =
COUNTROWS (
    FILTER ( ALL ( Tablel[Id] ), CALCULATE ( SUM ( Table2[Percentage] ) ) < .25 )
)
kunuthuri Member
Member

Re: DAX Expression

Thanks for replay