SSAS : Filter Cube

Question

I have dimension and fact table. The dimension is PATIENTDBOID meanwhile the fact table is Total_Admissions. Now, I want to filter for Patient that Admission >1

Can someone help me how. ?

Answer 1

You Can use Filter Function to Apply filter on Measures with Logical Expression.

Since I don't know Exact Dimension Name, You can try something like below.

0 - Represents COLUMNS

1 - Represents Rows

SELECT [Measures].[Total_Admissions] ON 0,

FILTER(
  [Patient].[Patient].[PatientDBOID].MEMBERS
, [Measures].[Total_Admissions]>1)
ON 1

FROM [Cube Name]