So can something like this happen? I'm trying to do

SUM(fact 1) GROUP BY dimension 1

, but GD doesn't let me. It just hides every single dimensions field (even from the main fact table). Alternatively I've tried turning the left side into a many-to-many relationship but that messes up the data and gives wrong values.

Hi Filip, you can slice and filter by datasets towards the left of the model. When using the BY clause, you will want to make sure that you are using the primary key, or connection point, to connect to the other objects accordingly. you can find more information here:

I read that, still didn't help. I changed the LDM to look like this, but now when I try to do AVG(fact 1) and in rows have dimension 1, it causes errors (I can't even drag it in there in new charts, it stays in the old ones), saying something about them not being in the same dimensionality. This works for non-fact tables that I use for filters (take field out of big table and put it into its own table so filters work faster), so why doesn't it work with facts?