Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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...
DAX
SSAS Tabular
Tabular Model
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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. 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    We ended up removing Offset count from the cube.