topic Re: Filter measure based on another measure in DAX Commands and Tips

Filter measure based on another measure

PacosdjNew — Tue, 23 Aug 2022 11:11:48 GMT

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

Re: Filter measure based on another measure

tamerj1 — Tue, 23 Aug 2022 12:39:56 GMT

Hi PacosdjNew

please try

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

Re: Filter measure based on another measure

PacosdjNew — Tue, 23 Aug 2022 14:49:48 GMT

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

Re: Filter measure based on another measure

tamerj1 — Tue, 23 Aug 2022 15:05:58 GMT

PacosdjNew

This should not make any difference

Re: Filter measure based on another measure

PacosdjNew — Tue, 23 Aug 2022 15:17:34 GMT

Below is the result obtained:

where the measure2 it's made as you suggest

Thanks for the support

Re: Filter measure based on another measure

tamerj1 — Tue, 23 Aug 2022 15:52:37 GMT

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

Re: Filter measure based on another measure

PacosdjNew — Tue, 23 Aug 2022 16:55:20 GMT

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

Thanks

Re: Filter measure based on another measure

tamerj1 — Tue, 23 Aug 2022 17:00:14 GMT

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?

Re: Filter measure based on another measure

PacosdjNew — Tue, 23 Aug 2022 17:18:24 GMT

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

Re: Filter measure based on another measure

tamerj1 — Tue, 23 Aug 2022 17:32:36 GMT

PacosdjNew
Please try

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

Re: Filter measure based on another measure

PacosdjNew — Wed, 24 Aug 2022 08:38:59 GMT

Thanks so much