DAX Formula for Measure

[diogovaz]

Good Evening,

I have this query in SQL

SELECT COUNT ( DISTINCT ID)
FROM
(SELECT DISTINCT ACC.ID
FROM ACC
INNER JOIN PKG ON (PKG.ACC_ID = ACC.ID AND PKG.create_timestamp>='2017-12-01 00:00:00' AND PKG.create_timestamp<='2018-01-01 00:00:00'
UNION
SELECT DISTINCT ACC.ID
FROM ACC
INNER JOIN OWN ON OWN.USER_ACC_ID = ACC.ID
INNER JOIN PASS ON PASS.OWNER_ID = OWN.ID AND PASS.create_timestamp>='2017-12-01 00:00:00' AND PASS.create_timestamp<='2018-01-01 00:00:00') TAB

There is any way to build this query in a Measure ?

Best Regards and Thanks,

Diogo

[Greg_Deckler]

Why would you want to do that versus just using this SQL Query as part of your import from your SQL database? I'm not sure I understand the ask here. Measures don't return tables generally.

[diogovaz]

Dear @Greg_Deckler,

I don't want to return table. If you see in the query I want to count how much disctinct ID's I have. In the data set model I already have the 4 tables that are in the query. 

My main purpose is only to count how many differents ID's I have since this will change everyday.

Thanks,

Diogo 

[Greg_Deckler]

You can probably use DISTINCTCOUNT and/or DISTINCT. If you can post example data then I could be more specific.