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
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
Can you provide any details?
Eg:
- do you need a calculated column, a measure, a table ...?
- table example
- result you expect
B.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
16 | |
13 | |
10 | |
8 |
User | Count |
---|---|
59 | |
20 | |
12 | |
11 | |
10 |