Forum Discussion
Solved
Power BI - CY, PY Calculation - DAX
Dear All, I have a request in PBI dax. I tried many things, but I am not sure what I am doing wrong. Can you please let me know the solution? Request: I have a date column (year). I pulled th...
Yes, ALLSELCTED() allows items in the filter context (your page filters) pass through to the calculation.
More information (with examples) on ALLSELECTED() can be found here:
https://www.sqlbi.com/articles/the-definitive-guide-to-allselected/ALL(), REMOVEFILTERS(), and ALLSELECTED() are key modifiers for the filter context in BI, any time spent understanding them is well worth while.
I tried
Cy = Calculate(Max(Date), ALLSELECTED(Date))
Cy = Calculate(Max(Date), ALLSELECTED(Table))
Both didn't work...
Finally I tried
Cy = Calculate(Max(Date), ALLSELECTED()) - nothing passed inside ALLSELECTED and it gave the expected result.
Is this correct? Just wanted to get it confirmed before publishing the report.
Thank you in advance.