Forum Discussion

Helper 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
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

smko

Helper I

4 years ago

I just want to understand how the [Wrong] measure come up with wrong result. I already knew the correct DAX to get the right result as shown in [Correct] measure