We have recently created an SSAS tabular model so our users can access it via PowerView. We have a measure on one of our fact tables to get the TotalActiveItems using a formula: ...
I'm currently building an education data warehouse. I have three factless fact tables for distinct set of grades due to the fact i have no measures (i'm not aggregating anything), the grades are ...
Calculated Measure to get only most current from one dimension on snapshot fact but keep other filters
I'm working on a tabular cube in SSAS 2012 SP1 CU4. I have 3 dimensions (Requisition, Requisition Status, Date) and 1 fact (Requisition Counts). My fact table is at the grain of requisitionKEY, ...