SQL to DAX

[diogovaz]

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

[v-jiascu-msft]

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