Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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.
Thanks, recommend me any other alternative to solve my problem?
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.
@h2danilo , do you need all selected there ? use that in measure .
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
51 | |
47 | |
16 | |
13 |