Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 |
---|---|
14 | |
11 | |
6 | |
6 | |
5 |
User | Count |
---|---|
29 | |
17 | |
11 | |
7 | |
5 |