Forum Discussion
DAX Expression to choose SSAS tabular model Measure based on Dimensional table selection.
I have desgined a tabular model cube in SSAS on transactionas. We have two facts one for transaction and one for offset transaction and there are multiple dimension tables. FACT_A - Transactions...
The Fact_B table is not used as a fact table in the cube tabular design instead it is used as a dimension table and added a relationship between Fact_A and Fact_B. I added count on Fact_B field but i am getting below results.
TRN_FACT_ID, POSTED_DATE, TRN_AMT, TNR OFFSET Amt, OFFSET COUNT
1 20221001 5000 2000 3
1 20221001 5000 3000 3
2 20221001 10000 10000 3
I am getting count as total number of rows in Fact_B table. not as per my selection.
We ended up removing Offset count from the cube.