topic Re: Remove all non-distinct values using a Direct Query model. in Developer

Remove all non-distinct values using a Direct Query model.

Drlazor — Tue, 10 Oct 2023 17:10:50 GMT

I have a dataset that has been set up in Azure Analytics services to try and optimize the speed of the dashboard. However, I would like to try and remove all non-distinct values from a column in the dataset for my dashboard. I cannot use Power Query as this is a Direct Query model, so is there another way to do this or will I need to alter the original dataset?

Any help is very appriecated. Thank you!

Re: Remove all non-distinct values using a Direct Query model.

lbendlin — Wed, 11 Oct 2023 22:39:48 GMT

Don't need to do anything, Power BI automatically aggregates data for you, if you want or not.

Put that column into a table visual and observe that only distinct values are shown.

Re: Remove all non-distinct values using a Direct Query model.

Drlazor — Mon, 16 Oct 2023 14:10:36 GMT

Sorry for getting back to you so late but the problem I am having with this is that I have tables like

Column A | Column B | Column C

A Beta Charlie

B Grama Delta

C Roho Sigma

A Beta Delta

I would like to remove all of the values in Column A with duplicate values. So after it is done it would looks somthing like this

Column A | Column B | Column C

A Beta Charlie

B Grama Delta

C Roho Sigma

Re: Remove all non-distinct values using a Direct Query model.

lbendlin — Mon, 16 Oct 2023 14:59:17 GMT

And why would A-Beta-Charlie be preferred to A-Beta-Delta ?

Re: Remove all non-distinct values using a Direct Query model.

Drlazor — Mon, 16 Oct 2023 15:03:29 GMT

I would like to keep the 1st instance of column A.

Re: Remove all non-distinct values using a Direct Query model.

lbendlin — Mon, 16 Oct 2023 16:30:25 GMT

Power BI does not have a concept of that. You need to bring your own sort order.