Forum Discussion
Filter only Top Level Value Matrix
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.
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.
2 Replies
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
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.
