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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

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.