topic Re: DAX Formula for Measure in Desktop

DAX Formula for Measure

diogovaz — Thu, 25 Jan 2018 15:55:07 GMT

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

Re: DAX Formula for Measure

Greg_Deckler — Thu, 25 Jan 2018 21:01:11 GMT

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.

Re: DAX Formula for Measure

diogovaz — Fri, 26 Jan 2018 09:43:06 GMT

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

Re: DAX Formula for Measure

Greg_Deckler — Fri, 26 Jan 2018 11:07:07 GMT

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