Hi, I want to create a calculate measure in my SSAS cube using mdx with following scenario .
Its basically a many to many case. I have DimSrc table that have unique transaction types and DimSrcAll table that have all the possible combination. I have a bridge table and created a relationship between DimSrc and Fact table using this bridge table. FactTable has keys present in DimSrcAll table.
Now I want to write a mdx if user selects value from filter(Filter is from DimSrc) like NB then only those records should come come that have NB key in Fact table. And if user selects NB and MB then those values should come that have NB_MB key in Fact table.
Thanks in advance