Filter measure based on another measure

[PacosdjNew]

I've two complex measure and i would that the Measure2  is valorized only if the Measure1 is valorized and consequently the Total of the Measure2 should respect this rule. For better understand, I would this situation:

I've already tried to add a conditional valorization on Measure2 [IF( Measure1<>0,Measure2,0)] but don't work because the Measure1 is valorized on the row of the total.

Please, how can i do it?

Thanks

[tamerj1]

Hi @PacosdjNew 

please try

Measure2new = IF( [Measure1]<>BLANK(),[Measure2])

[PacosdjNew]

Thanks but as said in the post it don't work because the Measure1 is valorized on the row of the total.

[tamerj1]

@PacosdjNew 

This should not make any difference 

[PacosdjNew]

Below is the result obtained:

where the measure2 it's made as you suggest

Thanks for the support

[tamerj1]

@PacosdjNew 
Is this is the expected result you are looking for? If not please indicate on the same screenshot the result that you would expect. If yes, kindly consider marking my reply as acceptable solution. Thank you

[PacosdjNew]

No... i would that the Measure2NEW is 4118 and not 4118+526 in the total.

Thanks

[tamerj1]

@PacosdjNew 
Yes this that be done. What are the names of the columns that are placed in the rows of your matrex? Are they from the same table?

[PacosdjNew]

On the row of the matrex there are fields from a dimension related to the fact on which are based the measures

[tamerj1 · Accepted solution]

@PacosdjNew 
Please try

Measure2new =
SUMX (
    SUMMARIZE ( Fact, Dim[Column1], Dim[Column2], Dim[Column3] ),
    IF ( [Measure1] <> BLANK (), [Measure2] )
)

[PacosdjNew]

Thanks so much