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

   

 

 

 

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

3 Replies

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    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

      • 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.