Forum Discussion
Solved
Translate SQL WHERE clauses to a query
Hi all! I have a very simple model with 2 tables - one fact with cases and history and one date dimension in SSAS. I need a measure to count open cases at the start of each contextualized period. So ...
johnsmith92 , if you do not have an active join between two tables then you do not need a crossfilter. Make both join inactive
Yes, using inactive relations between tables does the trick. 🙂
