Forum Discussion

afwork's avatar
afwork
Frequent Visitor
2 years ago
Solved

Switch not working when slicer is selected

Hello,   Please help. I am at a loss with this one.  This is my first time using Power BI and I have been trying to figure out why when I filter (using a slicer), the amount in Revenue does not ap...
afwork's avatar
afwork
Frequent Visitor
2 years ago

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's avatar
TomasAndersson
Icon for Solution Sage rankSolution Sage
2 years ago

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!

  • afwork's avatar
    afwork
    Frequent Visitor
    2 years ago

    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.