Use 2 measures in one column

Hi Anonymous ,

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.