Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
please try
Desv_02/23 =
IF (
ISFILTERED ( d_EAP[Nome de Projecto] ),
FORMAT ( ( SUMX ( d_EAP, d_EAP[BL1] - d_EAP[BL2] ) ), "###0" )
)
please try
Desv_02/23 =
IF (
ISFILTERED ( d_EAP[Nome de Projecto] ),
FORMAT ( ( SUMX ( d_EAP, d_EAP[BL1] - d_EAP[BL2] ) ), "###0" )
)
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
54 | |
35 | |
19 | |
19 | |
15 |