Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Mapping Data Tables

Hi-   Table 1 : I have a Data Table which gives me actuals by Posting Period (1,2,3....12), Product Category (A,B,C,D,E...), Reason Code (R1,R2..), Reason Category (C1, C2, C3), Date , company cod...
Need Help
parry2k's avatar
parry2k
Super User
4 years ago

Anonymous one way is to change the relationship cross filter to both which is not a recommended method, so better to create a measure that forces the cross filter to both

 

Sum Value = 
CALCULATE ( 
   SUM ( Table1[Value] ),
   CROSSFILTER ( Table1[Category], Table2[Category], BOTH )
)

 and use above measure in all the visuals.

 

✨ Follow us on LinkedIn

 

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡