Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good Morning guys,
I need help:
How can I transform this expression in SQL into a Measure in DAX:
select count(distinct id) from (select distinct _acc.id from eos_user_account _acc inner join eos_parking_session _pkg on (_pkg.account_id = _acc.id and _pkg.create_timestamp>='2018-01-01 00:00:00' and _pkg.create_timestamp<='2018-01-31 00:00:00') union select distinct _acc.id from eos_user_account _acc inner join eos_asset_owner _own ON _own.user_account_id = _acc.id inner join eos_consumable_consumable _pass on (_pass.owner_id = _own.id and _pass.create_timestamp>='2017-01-01 00:00:00' and _pass.create_timestamp<='2018-01-31 00:00:00')) t;
Thanks for your help,
Diogo
Hi @diogovaz,
Please share a dummy sample file. There are something we can't see from the SQL code. Such as,
1. The exact relationship, though we can see the join fields, it's the relationship fields works in DAX;
2. The relationship type (1:1, 1:*).
Best Regards,
Dale
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |