Show result in a card by a measure only if a row is selected on a matrix

[Gabe_Moreira]

Hi everyone!

So, I got an dashboard that shows when a certain phase of the project is seted to finish on a matrix, futhermore, I display the latest seted date (on the yellow triangle) and the previous forecast date (on red diamonds):

I've writed a measure that calculates deviation between this two dates:

Desv_02/23 = 
FORMAT(
    (SUMx(
        d_EAP,
        d_EAP[BL1] - d_EAP[BL2])),
    "###0")

The problem is that I wanted to display the result on this card only when a Row is selected at the matrix above, because this measure how it is today returns the whole calculation for every row on the matix.

I hope that you could understand this problem and that you could help me wiht this one! 

[tamerj1 · Accepted solution]

Hi @Gabe_Moreira 

please try

Desv_02/23 =
IF (
ISFILTERED ( d_EAP[Nome de Projecto] ),
FORMAT ( ( SUMX ( d_EAP, d_EAP[BL1] - d_EAP[BL2] ) ), "###0" )
)