Filter only Top Level Value Matrix

[Macwin]

Im currenctly trying to add a filter, so I can filter only the revenue of the top level of my Matrix.

Ive tried to create a dax like this

Total Revenue = 
IF(ISINSCOPE(Customer[Name]) && ISFILTERED('analysis'[Posting_Date].[Date]),
	VAR Total = CALCULATE(Sum((analysis[Revenue])))
	RETURN
		  Total
) 

So if I filter on this visual "Umsatz" > 30.000€ it should only display the first entry. But unfortunately it does not work. 

Another example:

"Umsatz" < 400€ : It shows still the first entry because there is a entry in the next level which has a value of less 400€

Thanks in advance.

[v-kkf-msft · Accepted solution]

Hi @Macwin ,

Please try the following formula:

Measure = SUMX ( ALLSELECTED ( analysis[Sub_category] ), [Total Revenue] )

Then use the measure to filter visual, like this:

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Macwin ,based on what I got

if this a parent because of order in rows Customer[Name]  then is always is in scope

so also use not ISINSCOPE for next levels