Forum Discussion
Use 2 measures in one column
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?
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.
2 Replies
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.