Forum Discussion
pedroccamaraDBI
Post Partisan
Post PartisanTREATAS with 2 conditions same table
Hello everyone, My budget measure with treatas is not working and i don't have enough knowledge to understand why. Besides your help, which is always amazing, could you explain me why? So, among o...
Hi,
The problem is in your time group columns. The values in the two tables don't match.
In Sales you have values:
Whereas in Budget you have:
So when treatas brings the filter over from Sales to budget nothing matches and you get a blank result.
littlemojopuppy
Community Champion
Community Champion
TREATAS is for taking a filter from one table and applying it to columns in another, unrelated table. Here's an article from Radacad that seems to cover what you intend to do (it's about halfway down the page).
Hope this helps!