Forum Discussion

diogovaz's avatar
diogovaz
Frequent Visitor
8 years ago

DAX Formula for Measure

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

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    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's avatar
      diogovaz
      Frequent Visitor
      8 years ago

      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's avatar
        Greg_Deckler
        Community Champion
        8 years ago

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