ALL/Groupby/Summerize Dax cannot be used in DirectQuery?

[Anonymous]

Dear all

I am trying to get uniqle combintation of three columns from a table I created by applying DirectQuery from Redshift.

Yet, I have tried ALL/GROUPBY/SUMMERIZE but still cannot return a table with all unique combinations.

Any idea why? Thank you for your help in advance!

 

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

We can use two ways to meet your requirement.

1. Create a measure that count the table rows, and filter out one row data.

count = COUNTROWS('table')

2. Create a calculate table that contains unique data.

Table1 = FILTER(GROUPBY('table','table'[ProductName],'table'[ProductID],'table'[Country]),CALCULATE(COUNTROWS('table'))=1)

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

Best regards,

[CheenuSing]

Hi @Anonymous ,

If you are using DirectQuery, can you change your query at the source to retun only distinct values of the 3 columns. 

You can not do this after the loading of data.

Cheers

CheenuSing