Forum Discussion
Created mesure is wrong
- 7 years ago
you can adjust the second measure with TREATAS/INTERSECT
https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/
Hi everyone,
I found my problem, and I don't think I can solve it.
The mesure 1 and 2 take their data in different tables. So I have two filter for the date for example, one filter for mesure 1, the other for mesure 2. So, when I adapt the first filter, mesure 1 is correct, but not mesure 2, so the new calculated mesure is wrong. And when I adapt the second filter, mesure 1 is wrong and mesure 2 isn't, so the new calculated mesure is wrong two.
I don't see a way to do it differently.
Thanks for your help
Tiff
- Stachu7 years agoCommunity Champion
you can adjust the second measure with TREATAS/INTERSECT
https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/- Tiff7 years agoHelper I
Thank you very much !