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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
phanisri19
Regular Visitor

convert sql query to dax

Hi Experts, 
I have sql query which needs to be converted to dax
select count(id) as total from master
where id in
(select distinct pid from master
where type = 'yes')
and type = 'neutral'.

Thanks,
Phanisri

3 REPLIES 3
BeaBF
Memorable Member
Memorable Member

Okay, but can you post an example of a table you run that query on? @phanisri19 

 

B.

BeaBF
Memorable Member
Memorable Member

Can you provide any details?

Eg:
- do you need a calculated column, a measure, a table ...?
- table example
- result you expect

 

B.

@BeaBF , I need either as a measure or column for the above query

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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