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,
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
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]))
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |