Forum Discussion
New vs Existing Patients
Hi All, I have patients medical claims data for 2 years FY 2017/2018 (FY runs from October 1st to Sept 30th). I have couple of tables like Fact_RX, DimProvider, DimDate,etc..The sample fact data ...
You must use ALLEXCEPT instead of ALL, just add ProviderID in ALLEXCEPT DAX expressions and on this way you could filter ProviderID.