Forum Discussion
Switch not working when slicer is selected
Hi, thanks for the data!
Names on tables and columns and data are bit different compared to your screenshot so it's difficult for me to verify that this is what you're looking for. But you can find the .pbix here and check. If I've misunderstood how your data is structured, please let me know.I'm assuming now there is a relationship between the tables.
I needed to add ALL('BTCDisplay table') to the total Revenue measure to make it sum in the table, like this:
EBITDA_Revenue = CALCULATE( [EBITDA_Revenue_Apple] + [EBITDA_Revenue_Orange], ALL('BTCDisplay table') )But with this it seems to work.
Does this fix your problem?
I figured out why they work now.
Since I removed the BTCDisplay table and then reinstated it. It removed the relationship between the tables. When I add the relationship again, the switch dax on [01Revenue] does not work.
Solution SageHi, thanks for the data!
Names on tables and columns and data are bit different compared to your screenshot so it's difficult for me to verify that this is what you're looking for. But you can find the .pbix here and check. If I've misunderstood how your data is structured, please let me know.
I'm assuming now there is a relationship between the tables.
I needed to add ALL('BTCDisplay table') to the total Revenue measure to make it sum in the table, like this:
EBITDA_Revenue =
CALCULATE(
[EBITDA_Revenue_Apple] + [EBITDA_Revenue_Orange],
ALL('BTCDisplay table')
)But with this it seems to work.
Does this fix your problem?
That worked! Thank you!!!!! Not sure if because of ALL().
I think it's because I opened your file. It mentioned something about your file being in a newer version. The reason I think that is because I have other measures adding up other measures like [01Revenue] but I didn't add ALL() to those, yet they somehow work now too.
This is what I did:
1. Opened your file
2. Opened my file, added ALL to [01Revenue]. It didn't seemed to work.
3. I removed BTCDisplay in my file and added it again.
4. Slicers now work.
WOW!
What version do you have?
Thank you again. I'm so excited! I really appreciated it.
- TomasAndersson
Huh, strange. Can't tell you why, but great that it works now!
I have version 2.137.751.0 64-bit (October 2024)
Glad I could help!
I figured out why they work now.
Since I removed the BTCDisplay table and then reinstated it. It removed the relationship between the tables. When I add the relationship again, the switch dax on [01Revenue] does not work.