Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

@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 )
)

Regards
Zubair

Please try my custom visuals

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

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 )
)

Regards
Zubair

Please try my custom visuals
Anonymous
Not applicable

Thanks for replay

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.