Applying filter to only some elements of the measure

[Giorgi1989]

Dear All,

Would appreciate a bit help on this:

I am using this formula:

• RM impact Apr 2022 = CALCULATE([RM impact Mar 2022]*(1+([Raw Mat %]*([RM index Apr 2022]/[RM index Mar 2022]-1))),ALL('RM index'[Month]))

I want ALL filter function NOT to apply to the sub-measure [Raw Mat %]. Any smart ways of doing this?

Thank you.

[Giorgi1989]

I seem to have resolved the issue I had, largely thanks to you. Many thanks! I will mark this as solved! 

[SpartaBI]

@Giorgi1989 my pleasure 🙂
Hey, check out my showcase report - got some high level stuff there 🙂
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up over there if you liked it 🙂

[SpartaBI · Accepted solution]

@Giorgi1989 

RM impact Apr 2022 =
	CALCULATE (
	    [RM impact Mar 2022],
	    ALL ( 'RM index'[Month] )
	)
	* ( 1 + ( [Raw Mat %] * CALCULATE( [RM index Apr 2022] / [RM index Mar 2022],ALL ( 'RM index'[Month] )) - 1 ) )

Showcase Report – Contoso By SpartaBI

      

[Giorgi1989]

Thank you for such a quick reply. 

The problem I have with that approach is that that would apply the filter to the [Raw Mat %] measure for priot month.

This is essentially how I have my formulae:

RM impact May 2022 = CALCULATE([RM impact Apr 2022]*(1+([Raw Mat %]*([RM index May 2022]/[RM index Apr 2022]-1))),ALL('RM index'))

RM impact Apr 2022 = CALCULATE([RM impact Mar 2022]*(1+([Raw Mat %]*([RM index Apr 2022]/[RM index Mar 2022]-1))),ALL('RM index'))

RM impact Mar 2022 = CALCULATE([RM impact Mar 2022]*(1+([Raw Mat %]*([RM index Mar 2022]/[RM index Feb 2022]-1))),ALL('RM index'))

RM impact Feb 2022 = CALCULATE([RM impact Feb 2022]*(1+([Raw Mat %]*([RM index Feb 2022]/[RM index jan 2022]-1))),ALL('RM index'))

Etc. until Jan 2021. 

[SpartaBI]

@Giorgi1989 hard to understand with the info supplied 🙂
In the version I sent the ALL hits all excpet the measure you wanted to exclude.
Maybe better to share a sample file with the desired results.