Forum Discussion

Macwin's avatar
Macwin
Helper I
4 years ago
Solved

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]) && ISF...
Need Help
Tutorial Requests
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    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's avatar
amitchandak
Super User
4 years ago

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