Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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]))
User | Count |
---|---|
12 | |
11 | |
8 | |
8 | |
6 |
User | Count |
---|---|
25 | |
19 | |
14 | |
10 | |
7 |