topic Re: AllSelected in a SUMMARIZE TABLE Rank in DAX Commands and Tips

AllSelected in a SUMMARIZE TABLE Rank

h2danilo — Thu, 29 Oct 2020 12:36:32 GMT

Hi guys,

I'm trying to create a summarize table Rank in a table context ALLSELECTED(Dados).

In my "Data" table it is apply some filters, and I would like to create a summarize table according to the filters applied to my Data table but is not working. My summarize is showing all the existing data in my Data table.

ALLSELECTED is not be applying in my SUMMARIZE.

Can someone explain why this is happening?

Re: AllSelected in a SUMMARIZE TABLE Rank

amitchandak — Thu, 29 Oct 2020 13:57:18 GMT

h2danilo , do you need all selected there ? use that in measure .

Re: AllSelected in a SUMMARIZE TABLE Rank

h2danilo — Thu, 29 Oct 2020 14:06:09 GMT

amitchandak , I need that my Summarize table show as the Dados Table with all filter apply.

Re: AllSelected in a SUMMARIZE TABLE Rank

Anonymous — Thu, 29 Oct 2020 14:29:27 GMT

ALLSELECTED is used in measures. It has no impact on tables created in the model. A table in the model must be and always is STATIC. It'll never change according to any selections in dimensions.

Re: AllSelected in a SUMMARIZE TABLE Rank

h2danilo — Thu, 29 Oct 2020 14:44:32 GMT

Thanks, recommend me any other alternative to solve my problem?

Re: AllSelected in a SUMMARIZE TABLE Rank

Anonymous — Thu, 29 Oct 2020 16:07:57 GMT

To do what you want, you have to create a suitable measure that you'll then use to filter your visual.

Re: AllSelected in a SUMMARIZE TABLE Rank

h2danilo — Thu, 29 Oct 2020 16:25:26 GMT

I thought about using summarize table because after creating the temporary table I want to validate if my table has less than 3 records I don't show anything, if I have more than 3 records I only show the records with rank above 3 but I don't know how can do that.