Forum Discussion
groupby
Hi Tom,
sample small dataset
https://www.dropbox.com/s/87mgmsb7u70jloe/Testcheckdale.pbix?dl=0
when the regions are filtered at "all" level, the interaction works perfectly fine (see above snapshot) , which is what my expected result should be (that means my outbound is interacting with inbound, pie and the table)
Now whats happening is when i filter for any region let say Northeast and then click on other outbound americas, i am not getting the above model results (refer below screenshot), (highligting in red means, they are not interacting with Outbound values) & the numbers of Pie and matrix are not in sync(i am fine with inbound, it may match or maynot)
let me know, why my model is not working?
Hey,
thanks for creating the sample data, but I have to admit I can't detect how the issue that you describe relates to your initial question creating a new table, representing a summariaztion of an existing tabel.
Sorry, but now I have to take some rest.
Regards
Tom
- vjnvinod8 years agoImpactful Individual
I did tried creating some middle tables, but thats not helping.
Do you have any solution to suggest for my problem?