Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Gabe_Moreira
Frequent Visitor

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

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):

Gabe_Moreira_0-1674668755172.png

 

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! 

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

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" )
)

View solution in original post

1 REPLY 1
tamerj1
Super User
Super User

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" )
)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors