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'...
Need Help
Show and Tell
Tips and Tricks
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.