Forum Discussion

PowerRobots99's avatar
PowerRobots99
Icon for Helper II rankHelper II
1 year ago
Solved

Drillthrough Interesting Challange

Hello Learners,   We have requirements wherein we have two measures, Measure A and Measure B, which fetches corresponding data after drilling through,   We have to develop Measure C on top of Mea...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • johnt75's avatar
    johnt75
    1 year ago

    You could create a measure like

    MeasureC =
IF (
    ISINSCOPE ( 'Table'[ID] ),
    SWITCH (
        TRUE,
        NOT ISBLANK ( [Measure A] ), "A",
        NOT ISBLANK ( [Measure B] ), "B"
    )
)

    as long as measures A and B are mutually exclusive

PowerRobots99's avatar
PowerRobots99
Icon for Helper II rankHelper II
1 year ago

Thank you for the reply,

But, what is Table['ID']?

johnt75's avatar
johnt75
Icon for Super User rankSuper User
1 year ago

That's intended to be the column you display in the table / matrix visuals.