All Selected is not working properly, I have to include another Column

john_elmasry — Fri, 31 Mar 2023 11:58:24 GMT

Hello,

I have a fact table that has multiple colums:

Item,Period_Name,Period_ID,Sales

Period name is like Jan 2022 , Feb 2022 etc

Period_ID is like 202201 , 202202 etc

I created one slicer in the dashboard that has "Period_Name" Field and created 1 grid in the dashboard in which I want to include 4 columns: Item, Period, Sales Value, Sales value (for the all selected periods) , Sales Value (for all the periods selected and unselected)

I created the measures like this

Total Value Sales = CALCULATE(SUM(Fact_Sales[Value Sales]))

Total Value Sales (Selected Period) = CALCULATE([Total Value Sales], ALLSELECTED(Fact_Sales[Period]))

Total Value Sales (Ignore Period) = CALCULATE([Total Value Sales], ALL(Fact_Sales[Period]))

But I got wrong results like the image

I tried so much to solve it and solved successfully by changing in the measures

Total Value Sales (Selected Period) = CALCULATE([Total Value Sales], ALLSELECTED(Fact_Sales[Period]),ALLSELECTED(Fact_Sales[PERIOD_ID]))

Total Value Sales (Ignore Period) = CALCULATE([Total Value Sales], ALL(Fact_Sales[Period]),ALL(Fact_Sales[PERIOD_ID]))

As you can see, numbers now are reflecting correctly... but I am unable to understand the behaviour, why it didn't work although I am not using this Period_ID column anywhere?

also I wanted to create another sheet with dummy data to upload here to the community to make things easier, but surprisingly it worked successfully without adding the second condition.

Does anyone have a clue?

Thanks.

John Elmasry

Re: All Selected is not working properly, I have to include another Column

john_elmasry — Fri, 31 Mar 2023 12:40:49 GMT

I found the solution to whom it may concern.

The reason is because the Period Column was sorted by Period ID Column, in this situation you have to include both columns in ALL and ALLSELECTED.

Refer to this video

https://youtu.be/rvpKSH3zRcg?t=465

Re: All Selected is not working properly, I have to include another Column

idonthaveaim — Thu, 24 Oct 2024 18:14:58 GMT

Wow, thank you for this. Never would have found this out if not for this post. I had the same problem.

Re: All Selected is not working properly, I have to include another Column

therynk — Tue, 01 Apr 2025 19:58:11 GMT

Same. I struggled with this for HOURS and this post helped me fix it. Thank you!

topic Re: All Selected is not working properly, I have to include another Column in DAX Commands and Tips

All Selected is not working properly, I have to include another Column

Re: All Selected is not working properly, I have to include another Column

Re: All Selected is not working properly, I have to include another Column

Re: All Selected is not working properly, I have to include another Column