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.

v-kkf-msft's avatar
v-kkf-msft
Community Support
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.