Forum Discussion

smko's avatar
smko
Icon for Helper I rankHelper I
4 years ago
Solved

Context transition on fact table

I am aware context transition should not be performed on fact table due to possibility of duplicate rows. The row context of duplicate rows will become one unique filter context, this I do understand...
Need Help
  • mangaus1111's avatar
    mangaus1111
    4 years ago

    In this example there is a multiplication between a measure [Sales] and a column [Com%], instead a multiplication between 2 columns. The scalar value of the measure [Sales] is always 16 beacause is independent from the row context.

     

    Please hit the thumbs up & mark it as a solution if it helps you. Thanks.

     

    MP                [Sales]           Com%

    LAZADA          16        *       0.075    =     1.2  

    LAZADA          16        *       0.075     =     1.2 

                                                                  _________

                                                                    2.4

aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
4 years ago

Hi smko 

Where is this column coming from?

try to use the column Date from the Table of the dataset

smko's avatar
smko
Icon for Helper I rankHelper I
4 years ago

Ops sorry, thats the attribute from my calendar dimension table, I have change to the date column from sales table

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Therefore you either add MonthYearNum to the fact table and use it in your visual or change the relationship to bidirectional between the Fact table and Calendar Table

    • smko's avatar
      smko
      Icon for Helper I rankHelper I
      4 years ago

      The column [Date] and [MP] in the visual are from fact table

      • aj1973's avatar
        aj1973
        Icon for Community Champion rankCommunity Champion
        4 years ago

        Here you go