AllSelected in a SUMMARIZE TABLE Rank

[h2danilo]

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. 

Dados table

Can someone explain why this is happening? 

[Anonymous]

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.

[h2danilo]

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

[Anonymous]

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

[h2danilo]

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.

[amitchandak]

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

[h2danilo]

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