Forum Discussion
Tonio_EG
3 years agoRegular Visitor
Filter on calculated measure not working
I have the following measure, which is working as expected: % Market Share = [Sales Amt]/Calculate([Sales Amt],ALL(Data[SellerName])) I then want to calculate this measure, which is puzzlingly r...
- 3 years ago
The answer is using KEEPFILTERS, as explained in this article:
https://www.sqlbi.com/articles/order-of-evaluation-in-calculate-parameters/
Tonio_EG
3 years agoRegular Visitor
The answer is using KEEPFILTERS, as explained in this article:
https://www.sqlbi.com/articles/order-of-evaluation-in-calculate-parameters/