Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

Allselected

Hi,
I am trying to understand what AllSelected does.
So, onto a page, I added a month slicer which is populated with month...
Then I have a card with the following DAX behind it:
myMeasure = calculate(countrows(table1,'Table2'[Month]) 

The measure gives the correct count when i selected different months in slicer...

 

Question:
The below DAX seems to work the same as the above DAX (Notice that I used AllSelected)
Then, what is the point of AllSelected then?
myMeasure = calculate(countrows(table1,AllSelected('Table2'[Month])) 

 

Thank  you

1 REPLY 1
Anonymous
Not applicable

If you used it in a chart with a month reference on x axis you seggest that you whant to calculate your measure on all the visible period of your chart.
Its best used when you want to calculate something in all of the sellected period + condition(Where date is less than latest('Date'[date]))

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.