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

mangaus1111's avatar
mangaus1111
Icon for Solution Sage rankSolution Sage
4 years ago

hi smko ,

 

a measure has no row context, then if you use the [Wrong] measure you get the following calculation:

MP                [Sales]           Com%

LAZADA          16        *       0.075    =     1.2  

LAZADA          16        *       0.075     =     1.2 

                                                              _________

                                                                2.4