How to use a filter for 2 tables, filter which contains same data, but can;t join table

Hello I have 2 tables one which contains sales and one with Warranties, i cant use a relation between those 2 table, they are allready joined by the data field, the problem is that both of them con...

Need Help

cristianj

Helper IV

4 years ago

Hello, this is my data model,

in fact i don;t need to filter all info, just to calculate, sum(ordersSM[TelefVandute]), if i select a timeframe in date - something like a month, i want to know, number of Warranty, interval, and the sum(ordersSM[TelefVandute]) for that period, and maybe filtered by contry and model . it would be better if i use a measure i think

Thank you

goncalogeraldes

Super User

4 years ago

Helo there cristianj ! Beware of extensive use of calculated columns. Due to the difference between Measures and Calculated Columns, you should always consider carefully which one to choose. There isn't a clear choice between which each one so you should consider the context of your model. However, my recommendation would be to avoid Calculated Columns in Fact tables as much as possible, specially in "heavy models" since they are going to be a burden on the refresh. Please use the following link for further documentation:

Calculated Columns and Measures in DAX - SQLBI

Regarding your question on filters, it is always better to model your data according to Power BI's best practices. Therefore, having a Country Dimension and a Model Dimension would be the best direction to go for now.

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

Forum Discussion

How to use a filter for 2 tables, filter which contains same data, but can;t join table