Use 2 measures in one column

[dkdirenzo]

Hi,

I tried using Switch, Switch True, functions for this but no variations seem to be working. I have 2 measures calculated and I want "PY Alts Book Yield" to apply where the row label = "Alternatives" and the "Book Yield" measure to apply for the other row labels. Is this possible without have to create a measure for each specific line item?

[Anonymous · Accepted solution]

Hi @dkdirenzo ,

Please see this example. I show the value of measure in ‘Canada’ and measure2 or null in the other fields.

Measure =
"test1"

Measure 2 =
"test2"

Measure3 =
IF (
    ISINSCOPE ( financials[Product] ),
    financials[Measure 2],
    IF ( MAX ( financials[Country] ) = "Canada", financials[Measure], BLANK () )
)

The ISINSCOPE function returns true when the specified column is a level in the level hierarchy. with the help of this function different values can be returned at different levels of the matrix, for more details see the documentation: ISINSCOPE function (DAX) - DAX | Microsoft Learn.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dkdirenzo]

This worked perfectly. Thank you so much!