I would like to filter dimensions using if else condition in calculated member (MDX query) using SSAS Cube. When I tried I get "0" wafer in value for dimension "Manufacturing Level" .
![ssas - How to filter by measure values in MDX while having dimension members in both axis - Stack Overflow ssas - How to filter by measure values in MDX while having dimension members in both axis - Stack Overflow](https://i.ibb.co/NSK4dN9/result-wrong.png)
ssas - How to filter by measure values in MDX while having dimension members in both axis - Stack Overflow
![sql server - having 'Measure' > 0 syntax does not work in mdx query - Database Administrators Stack Exchange sql server - having 'Measure' > 0 syntax does not work in mdx query - Database Administrators Stack Exchange](https://i.stack.imgur.com/bfH19.png)