Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
@Anonymous
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 ) )
Topic : finding how many employees are working in project with below 25 percentage work.
@Anonymous
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 ) )
Thanks for replay
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |