For large fact tables, the best approach is to create partitions which can then be processed individually. This is especially helpful in the cases where you have to process regularly.

Even...

Not sure I understand your question. Are you talking about processing an SSAS cube, or loading actual DW tables?

Fact and Dimension tables are very different in terms of design. Dimension...

I think it should be possible to achieve what you need...

You could use a case statement in the calculated measure, using the "currentmember" and "membervalue" functions to perform different calculations...

thomashohner (8/18/2016)

---

My question is would it be better to create a Stage and House for each customer instead of the single method we are doing now? Some of our fact...

Providing a direct answer is a little tough because of your obscure case, but I'll attempt to provide a few thoughts:

From your example, I wouldn't necessarily agree that the GameInningDim...

Doesn't look like anything is available yet. There's a new sample database ("World Wide Importers"), but no sign of SSAS Cubes or Report samples.

Assuming that your attribute notation was just a typo as it should look like this with Tenant at the far right:

TaskDimId -> Task Status -> Task Name -> Project N...

I'm unfortunately not familiar with these. Looking very briefly at the documentation though, it looks like you won't be able to do it without a library specifically...

CAWA?

You could use something like GIT or Visual Source Safe for version and change control. Not necessarily easy (or free) but probably the best way.

If all you're trying to do...

Definitely check the dimension usage and attribute relationships. Maybe your measure is counting rows from the wrong table?

No worries. Instead of returning an empty string ('') in your case statement, consider returning a null...I believe that nulls are excluded from distinct counts and you would therefore not...

patrick.w.wheeler (7/7/2016)

---

Martin thanks for following up. The order of operations make sense, almost like an aggregate on the outside of a case statement, however I was still unable to...

patrick.w.wheeler (7/6/2016)

---

Relatively new to DAX in Tabular SSAS.

Looking for a way to count distinct items that have to meet a LEN criteria.

Something like this

=IF(LEN([COLUMN1] > 4),...

Try the "ALLEXCEPT" DAX function, which allows you to remove context filters except the ones you specifically want to include. Reference: https://technet.microsoft.com/en-us/library/ee634795(v=sql.105).aspx