Drillthrough Interesting Challange

[PowerRobots99]

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 Measure A and Measure B, which would fetch entire data that fetched out by Measure A and Measure B, also we need additional flag in the drillthrough data indicating typical line row is from Measure A or Measure B.

Is this possible ?

[johnt75 · Accepted solution]

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]

Thank you for the reply,

But, what is Table['ID']?

[johnt75]

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