Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Distinct function shows wrong result

Hi Guys,   I have some issue with results on powerBI differing from DB. I have a query like this on DB:     SELECT DISTINCT(Sale_SK), DATE   FROM [dbo].[table_sales]   WHERE status='sold'  AND ...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Anonymous,

     

    You may use measure below.

    Measure =
COUNTROWS ( SUMMARIZE ( table_sales, table_sales[Sale_SK], table_sales[Date] ) )
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
7 years ago

Anonymous,

 

You may use measure below.

Measure =
COUNTROWS ( SUMMARIZE ( table_sales, table_sales[Sale_SK], table_sales[Date] ) )