Forum Discussion
Solved
Visual breaks with fields from two DIM tables
Dears, hope you can help me here, I'm getting nuts. Below you can see my data model. It has two FACT tables, which are related to two DIM tables. 1. Relationships - DIM Geo: one-to-many. To...
Hi Anonymous ,
I found a solution, and it has nothing to do with relationships. I keep my model as described.
I've implemented a SUM as amitchandak suggested in this post:
Total Turnover = CALCULATE(SUM('02b. FACT_Turnover'[Turnover]),FILTER('02b. FACT_Turnover','02b. FACT_Turnover'[Material] in VALUES('02a. FACT_Materials'[Material])))amitchandak , now I'd like to do a running total (or cummulative sum). I've successfully added a Rank column, and I'd like to do this running total using this column. Following my data mode described in this post, what do you suggest? I've tried this formula, but no success:Running Total =VAR currank2 = [Rank99]RETURNCALCULATE (SUMX('02b. FACT_Turnover',[Turnover]),FILTER(ALLSELECTED('02a. FACT_Materials'), [Rank99] <= currank2))Thanks,
ferryberry That looks like a relationship issue. I'd have to see what you're joining on. You might also need to modify the cross filter direction.
Hi Anonymous ,
I found a solution, and it has nothing to do with relationships. I keep my model as described.
I've implemented a SUM as amitchandak suggested in this post:
Total Turnover = CALCULATE(SUM('02b. FACT_Turnover'[Turnover]),FILTER('02b. FACT_Turnover','02b. FACT_Turnover'[Material] in VALUES('02a. FACT_Materials'[Material])))
amitchandak , now I'd like to do a running total (or cummulative sum). I've successfully added a Rank column, and I'd like to do this running total using this column. Following my data mode described in this post, what do you suggest? I've tried this formula, but no success:
Running Total =
VAR currank2 = [Rank99]
RETURN
CALCULATE (
SUMX('02b. FACT_Turnover',[Turnover]),
FILTER(ALLSELECTED('02a. FACT_Materials'), [Rank99] <= currank2)
)
Thanks,