Forum Discussion
Summarize table depending on several fact tables
I have built a table containg all active teams and their corresponding sales, shipments and cases which works fine. The goal is to create a table with only active teams which I can then use as a slic...
v-xjiin-msft
Solution Sage
Solution SageHi Markando,
Why don't you want to use SUMMARIZE()?
Per my understanding about your issue, the SUMMARIZE() should be the easiest way to achieve your requirement since you don't want to use Power Query.
Thanks,
Xi Jin.
Hi
I'm more then happy to use summarize()! However my question is how do i use a filter in either summarize or summarizecolumns to get a list as below depending on all the team-values that exist in either of the three fact tables