Forum Discussion
Post PartisanTREATAS with 2 conditions same table
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.
Post PartisanHello littlemojopuppy
All checked and accordingly to everything. Date table is marked as a date table. I don't have the family column, nor Type group column as a dimension table because they're a part of sales table.
And my model right now is pretty simple, both my budget and sales table are conencted to dates properly.
In my opinion, the problem is that measure with TREATAS. If i change the column name time group from sales to budget, it shows me correctly the budget by any period and wrong sales. But if that column is from sales, then i have the sales ok but not the budget.
Maybe this measure should be done in another way. I don't know.
And i am very sorry to say but my data are a litle sensitive, at least for public. But i apreciate very much if you send me your email by message to me.
Thanks a lot for all your help
P.S i don't have a Family dimension table not a type group dimension table
Community Champion
I think it would be rare for any of us to do this for fun (except maybe for an interest we might have such as sports). The guys that work for me have instruction to look for as much help as they can get from people in this forum (including me, but they can always ask me at work) but to never, ever share confidential data because that's the kind of thing that gets people fired. So I completely understand. 🙂
Let me try to convince you of this: take 100 records from each of your Sales and Budget tables and drop them into Excel. Change details so you have family of "XYZ" or named after fruits (Apple, Banana, Orange, Mango, etc.) Change the amounts too if you like. Just include all columns from each table and I'll figure this out.
- littlemojopuppy
I want to add that with people in the forum who ask "this is what I want go make it for me" I'm a kind of an ass to, because it's clear they're not trying. You're different: you are trying! So I'm willing at help you as much as possible 🙂