Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

sql to DAX

Hi, Can you please let me know if the following sql should give the same result as the followed DAX? Thank you   select p.[field1], count(distinct p.[field3]) AS "Mycount" from TableP AS p IN...
  • Anonymous's avatar
    Anonymous
    6 years ago

    You can go ahead with anything as long as it's giving the correct result.. :)

    Thanks.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Try to use below DAX. Just replace your table and column names.

You can add more filters too.

FILTER( CALCULATETABLE( SUMMARIZECOLUMNS(DimProduct[EnglishProductName], 
		DimProduct, 
		"Mycount", 
		DISTINCTCOUNT( FactInternetSales[OrderDate]) 
		) 
	),
	CALCULATE(DISTINCTCOUNT( FactInternetSales[OrderDate])) >= 3 &&
	DimProduct[EnglishProductName]="some text"
)

Thanks.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,
This seems to be giving the similar result to my filter and summarize dax

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    You can go ahead with anything as long as it's giving the correct result.. :)

    Thanks.